IBM P2090-045 - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam
Page: 3 / 11
Total 55 questions
Question #11 (Topic: )
InfoSphere Data Architect is not part of the Information Server Suite. Which statement
about sharing metadata with the Metadata Repository is correct?
about sharing metadata with the Metadata Repository is correct?
A. Metadata CANNOT be imported into the Metadata Repository from Data Architect
B. Only a physical model can be exported from Data Architect to the Metadata Repository
C. Only a logical model can be exported from Data Architect to the Metadata Repository
D. Both, a physical model and a logical model can be exported from Data Architect to the Metadata Repository
Answer: D
Question #12 (Topic: )
Which of the following statements about InfoSphere Data Architect is correct?
A. You CANNOT create a logical model from a physical model
B. InfoSphere Data Architect can deploy physical data models directly to the database management system
C. Reverse engineering data models only works for DB2 databases
D. InfoSphere Data Architect is installed using the Information Server installation wizard
Answer: B
Question #13 (Topic: )
The ODBC Connector Stage can be used to connect to __________.
A. Oracle database
B. Teradata database
C. DB2 database
D. All of the above
Answer: D
Question #14 (Topic: )
Which of the following statements about Collecting methods is correct?
A. ROUND ROBIN is the fastest algorithm
B. SORT MERGE never performs data sorting
C. ORDERED ensures the collected data stream being sorted
D. AUTO chooses the best method between ROUND ROBIN, SORT MERGE, and ORDERED
Answer: B
Question #15 (Topic: )
Which of the following is a standard practice when using partition parallelism?
A. Disable the pipeline parallelism for all the stages that can run in parallel
B. Setup a configuration file defining multiple CPUs for each logical node
C. Avoid repartitioning if possible
D. All of the above
Answer: C
