IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 認定 P2090-045 試験問題:

1. What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?

A) Stage reports an error
B) Stage rejects the Input record
C) Job gets aborted
D) Stage skips the input record

2. Which of the following statements about partitioning algorithms is correct?

A) The grouping methods available in the Aggregator stage are MODULUS and HASH
B) For the Lookup reference stage, DataStage always uses the MODULUS method
C) SAME partitioning method is the fastest algorithm because it does not require additional processing
D) MODULUS and HASH ensure balanced data volumes in all the partitions

3. 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) Run two different parallel jobs in sequence and use job parameters to pass different $APT_CONFIG _FILE values for each of them
C) Create multiple Exception Handlers stages to handle different types of failures
D) Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory

4. In a Job Sequence, what is the purpose for the use of Checkpoints?

A) Record the log information for each trigger
B) Automatically restart a job
C) Monitor performance and failure for each stage
D) Restart a job from the latest Checkpoint in case of job failures

5. Which Stage requires identical metadata in order to combine data?

A) Lookup Stage
B) Transformer Stage
C) Join Stage
D) Funnel Stage

質問と回答：