IBM IBM Certifications P2090-045 Questions & Answers

• Question 1:

  Which of the following is a standard practice when using partition parallelism?

  A. Disable the pipeline parallelism for all the stages that can run in parallel

  B. Setup a configuration file defining multiple CPUs for each logical node

  C. Avoid repartitioning if possible

  D. All of the above

  Correct Answer: C

• Question 2:

  A DataStage job can be executed from_______________

  A. DataStage Administrator client only

  B. DataStage Administrator or Director client

  C. DataStage Director client only

  D. DataStage Designer or Director client.

  Correct Answer: D

• Question 3:

  Which of the following statements is not a supported matching option of the Lookup Stage?

  A. Equality match

  B. Caseless match

  C. Range on the Target Link

  D. Range on the Reference Link

  Correct Answer: C

• Question 4:

  Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?

  A. Multiple bindings can be associated to the same service

  B. The choice of binding depends on the information provider used

  C. Bindings are set at the application level

  D. Bindings are set at the individual operation level

  Correct Answer: A

• Question 5:

  Which description below about the Sort Stage is invalid?

  A. Sort Stage uses temporary disk space while performing sort

  B. It has a property to create a Key Change Column

  C. All the incoming records must have different values for sorting key

  D. Sort can be executed in sequential mode or parallel mode

  Correct Answer: C

• Question 6:

  What is a descriptor file of a Dataset created by the Dataset Stage?

  A. Contains the length of the data files

  B. Contains metadata, data location, but not the data itself

  C. Contains the actual data in text format

  D. Contains the actual data in binary format

  Correct Answer: B

• Question 7:

  DataStage Parallel Engine supports __________.

  A. Pipeline and Partition Parallelism

  B. Pipeline Parallelism only

  C. Partition Parallelism only

  D. None of the above

  Correct Answer: A

• Question 8:

  Which functionalities are supported by InfoSphere Discovery?

  I.Discover primary / foreign key relationships between tables II.Discover statistics about usage of data by users III.Discover matching source and target columns IV.Discover suggested transformations that, when applied, will transform the data from the source columns to match the data in the target columns

  A. I, II, IV

  B. I, III, IV

  C. I, II, III

  D. II, III, IV

  Correct Answer: B

• Question 9:

  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, 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

  Correct Answer: A

• Question 10:

  Which of the following is NOT a function provided by the DB2 Connector Stage?

  A. Deletes rows from a DB2 table

  B. Reads a DB2 table

  C. Automatically updates table definitions when a SQL type mismatch is detected

  D. Performs a lookup directly on a DB2 table

  Correct Answer: C