IBM P2090-045 - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam
Page: 2 / 11
Total 55 questions
Question #6 (Topic: )
Which of the following stages is NOT a file data access stage?
A. Sequential File Stage
B. Transformer Stage
C. Dataset Stage
D. FileSet Stage
Answer: B
Question #7 (Topic: )
A Transformer Stage can have __________.
A. One input link, one or more reject links, one otherwise link, one or more output links
B. One or more input links, one or more reject links, one otherwise link, one or more output links
C. One input link, one reject link, one otherwise link, one or more output links
D. One or more input links, one reject link, one otherwise link, one or more output links
Answer: C
Question #8 (Topic: )
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?
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, SAME ensures groups of rows stays together
B. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together
C. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results
D. ROUND ROBIN ensures correct results
Answer: A
Question #9 (Topic: )
A file contains a very large number of records with unique groups based on a key. Which
Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?
Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?
A. Hash
B. Sort
C. Random
D. Round Robin
Answer: B
Question #10 (Topic: )
Which of the following statements about FastTrack is incorrect?
A. The only way to combine data in a FastTrack mapping specification is to create a lookup definition
B. When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems
C. When generating a job from a FastTrack specification, you can specify the desired stage type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)
D. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations
Answer: A
