IBM P2090-046 - IBM InfoSphere Business Information Exchange Technical Mastery Test v1 Exam
Page: 1 / 12
Total 59 questions
Question #1 (Topic: )
For the Information Server Repository, which Relational Database Management System
(RDMS) CANNOT be used?
(RDMS) CANNOT be used?
A. Microsoft SQL Server
B. Informix
C. DB2 UDB
D. Oracle
Answer: B
Question #2 (Topic: )
Where are Table Definitions stored?
A. Information Server metadata repository
B. In the file system as a binary file
C. In the file system as a csv file
D. None of the above
Answer: A
Question #3 (Topic: )
Which of the following is a valid Write Table action in the Connector Stages?
A. Append
B. Replace
C. Truncate
D. All of the above
Answer: D
Question #4 (Topic: )
Which type of Join would you select for the Join Stage to output unmatched records from
both input data sources?
both input data sources?
A. Inner join
B. Left outer join
C. Right outer join
D. Full outer join
Answer: D
Question #5 (Topic: )
In a Job Sequence, what is the purpose for the use of Checkpoints?
A. Monitor performance and failure for each stage
B. Automatically restart a job
C. Record the log information for each trigger
D. Restart a job from the latest Checkpoint in case of job failures
Answer: D
