P2090-045 Exam Training Practice Tests (IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1)]

Question 1

Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?

A. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results B. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together C. ROUND ROBIN ensures correct results D. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together

Correct Answer: B

Question 2

Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct?

A. You can only use existing, predefined queries B. Queries can report on objects that are not stored in the Metadata Repository C. Queries can be saved in XML format D. In a query, the criteria used for filtering the desired metadata can be based on different asset types

Correct Answer: D

Question 3

A Job Sequence CANNOT contain __________.

A. Triggers B. Transformer Stages C. Sequencer Stages D. Job Activity Stages

Correct Answer: B

Question 4

The ODBC Connector Stage can be used to connect to __________.

A. Teradata database B. Oracle database C. DB2 database D. All of the above

Correct Answer: D

Question 5

Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?

A. 0 indicates the key value has not changed B. 1 indicates the key value has changed C. Adds a column which holds a value of true/false D. Adds a column which holds a value of 0 or 1

Correct Answer: C

Question 6

Which of the following stages is NOT a file data access stage?

A. Sequential File Stage B. FileSet Stage C. Dataset Stage D. Transformer Stage

Correct Answer: D

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