IBM P2090-045 - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam
Page: 1 / 12
Total 55 questions
Question #1 (Topic: )
Which of the following is NOT a valid File Update Mode property setting of a Sequential
File Stage?
File Stage?
A. Append
B. Overwrite
C. Delete
D. Create
Answer: C
Question #2 (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 #3 (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 #4 (Topic: )
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 (Topic: )
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?
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
Answer: C
