IBM P2090-045 Free Practice Exam & Test Training

IBM P2090-045 - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam

Page: 1 / 11
Total 55 questions

Question 1

Which of the following is NOT a valid File Update Mode property setting of a Sequential
File Stage?

A. Append
B. Overwrite
C. Delete
D. Create

Answer : C

Question 2

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 3

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

Question 4

Which of the following statements about the Lookup Stage is correct?

A. It is a Real-Time Stage
B. It combines data horizontally
C. It can have only one input link defined
D. The default partition method for Lookup is Hash

Answer : B

Question 5

In which situation below can you use the Metadata Asset Manager with the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?

A. To bring runtime information about DataStage jobs into the Metadata Repository
B. To bring FastTrack mapping specifications into the Metadata Repository
C. To bring Cognos BI reports and queries into the Metadata Repository
D. To bring a blueprint from Blueprint Director into the Metadata Repository