IBM P2090-046 Certification Exam Material - Free Download and Guaranteed Pass

IBM P2090-046 Certification Exam Material - Free Download and Guaranteed Pass



Exam code : P2090-046
Exam name : IBM InfoSphere Business Information Exchange Technical Mastery Test v1

For the Information Server Repository, which Relational Database Management System
(RDMS) CANNOT be used?
A. Microsoft SQL Server
B. Informix
C. DB2 UDB
D. Oracle
Answer: B
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
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
Which type of Join would you select for the Join Stage to output unmatched records from
both input data sources?
A. Inner join
B. Left outer join
C. Right outer join
D. Full outer join
Answer: D
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
Using a Job Sequence, which of the following tasks CANNOT be performed?
A. Define specific user variables and make them available within a Job Sequence
B. Drop a database table using a script, then start two different parallel jobs in sequence
when a file appears in a specific directory
C. Run two different parallel jobs in sequence and use job parameters to pass different
$APT_CONFIG _FILE values for each of them
D. Create multiple Exception Handlers stages to handle different types of failures
Answer: D