IBM IBM Certifications C2090-424 Questions & Answers

• Question 21:

  Which client Tool is used to export environment variables from a Project?

  A. InfoSphere DataStage Director

  B. InfoSphere DataStage Manager

  C. InfoSphere DataStage Designer

  D. InfoSphere DataStage Administrator

  Correct Answer: D

• Question 22:

  You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?

  A. Hash partition on TotalAmount. Sort on CustID, ProductType and TotalAmount

  B. Hash partition on ProductType. Sort on CustID, ProductType and TotalAmount

  C. Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount

  D. Hash partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount

  Correct Answer: C

• Question 23:

  A job is designed with 3 Join stages in sequence.

  Join_1 keys are "Account", "Customer" and "PO_Date"

  Join_2 keys are "Account", "Customer" and "Txn"

  Join_3 keys are "Account", "Product_CD" and "Txn"

  Which of the following will lead to the best run time performance?

  A. Left links are Hash partitioned on "Account" for all joins Right links are Hash partitioned on "Account" for all joins

  B. Both left and right links are Hash partitioned as follows: Join_1 by "Account", "Customer" and "PO_Date" Join_2 by "Account", "Customer" and "Txn" Join_3 by "Account", "Product_CD" and "Txn"

  C. Both left and right links are Hash partitioned as follows: Join_1 by "Account" and "Customer" Join_2 by "Account" and "Customer" Join_3 by "Account"

  D. Left links are Hash partitioned on "Account" for the first two joins and on "Product_CD" for the third. Right links are Hash partitioned on "Account" for all joins

  Correct Answer: A

• Question 24:

  Which statement about shared containers is TRUE?

  A. A shared container is an independently compiled unit

  B. A local container can be converted to a shared container

  C. A shared container can be converted to a local container

  D. A container cannot be created by selecting a group of stages and links in a job

  Correct Answer: B

• Question 25:

  Which of the following is the correct schema format for a Time column?

  A. record (tField:time[hour:minute:second];)

  B. record (tField:nullable time[];)

  C. record (tField:time[seconds];)

  D. record (tField:time[microseconds];)

  Correct Answer: C

• Question 26:

  Record Count property is set to zero in Connector stage. How many rows are written out?

  A. All Rows

  B. One Row

  C. Zero Rows

  D. 2000 Rows

  Correct Answer: A

• Question 27:

  Which statement is TRUE?

  A. The configuration file needs to be copied to all processing nodes

  B. The configuration file needs to be copied to the conductor nodes and all processing nodes

  C. The configuration file needs to be copied to all nodes to which the parallel engine has been configured

  D. The configuration file only needs to be copied to the conductor nodes from which parallel engine applications are started

  Correct Answer: D

• Question 28:

  Which partitioning method requires a key?

  A. Entire

  B. Same

  C. Range

  D. Random

  Correct Answer: B

• Question 29:

  When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?

  A. Set format's fill char option using the value

  B. Set string type default option using the value

  C. Set format's null field value option using the value

  D. Set $APT_IMPEXP_REJECT_NULLS using the value

  Correct Answer: B

• Question 30:

  Which of the following statements about checkpoint/restart is TRUE?

  A. The parallel framework does not support checkpoints inside jobs

  B. You must set the environment variable $APT_DISABLE_COMBINATION to TRUE

  C. To perform checkpoint inside a parallel job, select the checkpoint option in each stage

  D. If the checkpoint/restart is turned on for a sequence job, all components of this sequence job must perform checkpoint recording

  Correct Answer: A