IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 91:

  Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)

  A. Input stage

  B. Basic stage

  C. Group stage

  D. Custom stage

  E. Wrapped stage

  Correct Answer: DE

• Question 92:

  Which derivations are executed first in the Transformer stage?

  A. Input column derivations

  B. Loop variable derivations

  C. Stage variable derivations

  D. Output column derivations

  Correct Answer: C

• Question 93:

  In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)

  A. Integer input column mapped to raw output column.

  B. Date input column mapped to a string output column.

  C. String input column mapped to a date output column.

  D. String input column mapped to integer output column.

  E. Integer input column mapped to string output column.

  Correct Answer: DE

• Question 94:

  In the Slowly Changing Dimension stage, a dimension columns Purpose code property can trigger which two actions. (Choose two.)

  A. Update fact table keys.

  B. Detect dimension changes.

  C. Update the dimension table.

  D. Insert rows into the fact table.

  E. Delete duplicate dimension table rows.

  Correct Answer: BC

• Question 95:

  Which statement is true when using the SaveInputRecord() function in a Transformer stage.

  A. You can only use the SaveInputRecord() function in Loop variable derivations.

  B. You can access the saved queue records using Vector referencing in Stage variable derivations.

  C. You must retrieve all saved queue records using the GetSavedInputRecord() function within Loop variable derivations.

  D. You must retrieve all saved queue records using the GetSavedInputRecord() function within Stage variable derivations.

  Correct Answer: C

• Question 96:

  Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?

  A. An input column value flows into a target column only if it matches it by name.

  B. An input column value flows into a target column only if it is explicitly mapped to it.

  C. You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur.

  D. An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.

  Correct Answer: B

• Question 97:

  A customer must compare a date column with a job parameter date to determine which output links the row belongs on. What stage should be used for this requirement?

  A. Filter stage

  B. Switch stage

  C. Compare stage

  D. Transformer stage

  Correct Answer: D

• Question 98:

  Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

  A. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable named sv_Product. Map the Input.Product column to sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES" ELSE "NO".

  B. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable named sv_Product. Map the Input.Product column to sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES" ELSE "NO".

  C. Create a stage variable named sv_Product and follow it by a second stage variable named sv_IsNewProduct. Map the Input.Product column to sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES" ELSE "NO".

  D. Create a stage variable named sv_Product and follow it by a second stage variable named sv_IsNewProduct. Map the Input.Product column to sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES" ELSE "NO".

  Correct Answer: B

• Question 99:

  Identify two items that are created as a result of running a Balanced Optimization on a job that accesses a Hadoop distributed file system as a source? (Choose two.)

  A. A JAQL stage is found in the optimized job result.

  B. A Big Data File stage is found in the optimized job results.

  C. A Balanced Optimization parameter set is found in the project

  D. A Balanced Optimization Shared Container is found in the project.

  E. A MapReduce Transformer stage is found in the optimized job result.

  Correct Answer: AC

• Question 100:

  Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)

  A. Data Set Stage

  B. Compare Stage

  C. Big Data File Stage

  D. Lookup File Set Stage

  E. Complex Flat File Stage

  Correct Answer: CE