IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 61:

  Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?

  A. Adds a new row to the fact table.

  B. Adds a new row to a dimension table.

  C. Overwrites an attribute in the fact table.

  D. Overwrites an attribute in a dimension table.

  Correct Answer: D

• Question 62:

  Which derivations are executed last in the Transformer stage?

  A. Input column derivations

  B. Loop variable derivations

  C. Output column derivations

  D. Stage variable derivations

  Correct Answer: C

• Question 63:

  Which stage classifies data rows from a single input into groups and computes totals?

  A. Modify stage

  B. Compare stage

  C. Aggregator stage

  D. Transformer stage

  Correct Answer: C

• Question 64:

  When using the loop functionality in a transformer, which statement is true regarding Transformer processing.

  A. Stage variables can be referenced in loop conditions.

  B. Stage variables can be executed after loop variable expressions.

  C. Loop variable expressions are executed before input link column expressions.

  D. Output links can be excluded from being associated with a True loop condition.

  Correct Answer: A

• Question 65:

  In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format properties. What two items are true in configuring this stage in your parallel job? (Choose two.)

  A. Enable Run Time Column propagation.

  B. Enable Run Time Schema propagation.

  C. Configure the column tab with one column named 'Input'.

  D. Configure the Schema File property with the path of the schema file definition.

  E. Configure the APT_SEQFILE_HASSCHEMA property with the schema file path.

  Correct Answer: AD

• Question 66:

  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 67:

  In a Transformer expression for a stage variable, there is a nullable input column. Assume the legacy NULL processing option is turned off. What happens when a row is processed that contains NULL in that input column?

  A. The job aborts.

  B. The row is rejected.

  C. NULL is written to the stage variable.

  D. The value written to the stage variable is undetermined.

  Correct Answer: C

• Question 68:

  Which Oracle Connector stage property can be set to tune job performance?

  A. Array size

  B. Memory size

  C. Partition size

  D. Transaction size

  Correct Answer: A

• Question 69:

  Which two statements about using a Load write method in an Oracle Connector stage to tables that have indexes on them are true? (Choose two.)

  A. Set the Upsert mode property to "Index".

  B. Set the Index mode property to "Bypass".

  C. The Load Write method uses the Parallel Direct Path load method.

  D. The Load Write method uses "Rebuild" mode with no logging automatically.

  E. Set the environment variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)".

  Correct Answer: CE

• Question 70:

  Which Oracle data type conversion is correct?

  A. Oracle data type RAW converts to RAW in Oracle Connector stage.

  B. Oracle data type NUMBER(6,0) converts to INT32 in Oracle Connector stage.

  C. Oracle data type NUMBER(15,0) converts to INT32 in Oracle Connector stage.

  D. Oracle data type NUMBER converts to DECIMAL(38,0) in Oracle Connector stage.

  Correct Answer: B