IBM IBM Certifications C2090-424 Questions & Answers

• Question 31:

  Which of the following will determine the running row number within a group?

  A. Insert an Aggregator stage, hashing on the key column, prior to the Transformer stage

  B. Use a Surrogate Key Generator stage to generate the running row number prior to the Transformer stage

  C. Use a Remove Duplicates stage prior to the Transformer stage based on the key column, with the Duplicate set to retain = last option

  D. Use a Sort stage prior to the Transformer stage based on the key break column. Then, use the LastRowinGroup() function to determine the last row in a group

  Correct Answer: D

• Question 32:

  Which of the following is an FTP Collection method?

  A. Hash

  B. Same

  C. Random

  D. Sort Merge

  Correct Answer: D

• Question 33:

  Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage. The following two Balanced Optimizer options have been selected: Push processing to data sources Push processing to data targets The following two Balanced Optimizer options have NOT been selected: Push data reduction processing to data targets Push all processing into the (target) data server Assuming the job design allows for maximum optimization, what does the optimized job design look like?

  A. Row Generator stage followed by a DB2 Connector stage

  B. DB2 Connector stage followed by a DB2 Connector stage

  C. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage

  D. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage

  Correct Answer: A

• Question 34:

  You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job.

  What steps should you take to understand the job performance issues? (Choose two.)

  A. Use the resource estimation tool

  B. Use the performance analysis tool

  C. Replace Join stages by Lookup stages

  D. Run the job with $APT_TRACE_RUN set to true

  E. Run the job with $APT_DUMP_SCORE set to true

  Correct Answer: BE

• Question 35:

  When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

  A. Predicates cannot refine what rows are updated

  B. Table(s) referenced must have table definitions imported previously

  C. Column values can be job parameters or input columns but not expressions

  D. Columns to update must be selected individually from the column selection grid

  Correct Answer: D

• Question 36:

  How do you create a shared table definition from the DataStage client?

  A. Use the save button on the columns tab of the stage editor

  B. Use the shared table creation wizard from the repository window

  C. Do nothing. They are created automatically when table definitions are imported

  D. It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.

  Correct Answer: B

• Question 37:

  Which restructure stage has a single reject link?

  A. Split Vector

  B. Column Import

  C. Make Subrecord

  D. Combine Records

  Correct Answer: D

• Question 38:

  Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1 for the user srv_etl?

  A. dsjob –domain is1:9445 –server is1 –user srv_etl –run dstage1 jTest101

  B. dsjob –domain is1:9445 –server is1 –userid srv_etl –password {iisenc}infosphere –run dstage1 jTest101

  C. dsjob –domain is1:9445 –server is1 –username srv_etl –password iisenc_infosphere –run dstage1 jTest101

  D. dsjob –domain is1:9445 –server is1 –user srv_etl –password {iisenc} QHw0Q6i1zBuHhM3HcHPQrw= = -run dstage1 jTest101

  Correct Answer: B

• Question 39:

  Which is NOT a valid native operator for OSH?

  A. Sort

  B. Copy

  C. Import

  D. Generator

  Correct Answer: A

• Question 40:

  A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage?

  A. Auto

  B. Same

  C. Round robin

  D. Sorted merge

  Correct Answer: D