IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 21:

  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
  D. Transformer stage

• Question 22:

  Click the Exhibit button.

  

  The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime meta-data will help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

  A. $APT_PM_PLAYER_STATS
  B. Job Monitor Tool in the Director Client
  C. Show Performance Statistics in the Designer.
  D. Use job run operational meta-data reports from IS Manager.
  B. Job Monitor Tool in the Director Client
  C. Show Performance Statistics in the Designer.

• Question 23:

  A customer wants to select the entire order details for the largest transaction for each of 2 million customers from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

  A. Partition on customer key,sort on customer key and transaction amount,remove duplicates on customer key.
  B. Use a Sort Aggregator stage with calculated column based on the maximum value of transaction amount column.
  C. Partition and sort the input to a Filter stage by customer number. Filter with the clause "MAX (transaction_amount)".
  D. Partition and sort the input to a RemoveDuplicates stage using the customer key and transaction amount columns. Remove duplicates on customer key.
  A. Partition on customer key,sort on customer key and transaction amount,remove duplicates on customer key.

• Question 24:

  Which three DataStage elements allow you to create Shared MetaData? (Select three)

  A. DB2 Connector
  B. Oracle Connector
  C. Dataset stage
  D. Sequential file stage
  E. DataStage table definition
  A. DB2 Connector
  C. Dataset stage
  E. DataStage table definition

• Question 25:

  Which two statements are accurate regarding usage of database stages? (Choose two.)

  A. Plug-in stages match columns by name.
  B. Native database stages match columns by name.
  C. DataStage provides native Oracle database stages.
  D. Database stages cannot create tables and must be done externally.
  B. Native database stages match columns by name.
  C. DataStage provides native Oracle database stages.

• Question 26:

  A job design consists of an input SequentialFile stage, followed by a Peek stage, a Transformer stage, a Sort stage and finally an output Dataset stage. The job executes on an SMP system with a configuration file defined with 4 nodes.

  The environment variable $APT_DISABLE_COMBINATION is set to "True". How many processes will this job create?

  A. 12
  B. 17
  C. 19
  D. 21
  B. 17

• Question 27:

  What two stages are required to place Header and Detail records, which have different formats, into a single format? (Choose two.)

  A. Funnel Stage
  B. Combine Stage
  C. Column Export Stage
  D. Column Import Stage
  A. Funnel Stage
  C. Column Export Stage

• Question 28:

  You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are three valid ways to do this? (Choose three.)

  A. Use local parameters.
  B. Use environment variables.
  C. Place a parameter set stage on the job sequence.
  D. Check the "Propagate Parameters" checkbox in the Sequence Job properties.
  E. Use the UserVariablesActivity Stage to populate the local parameters from an outside source such as a file.
  A. Use local parameters.
  B. Use environment variables.
  E. Use the UserVariablesActivity Stage to populate the local parameters from an outside source such as a file.

• Question 29:

  A job reads from a sequential file using a SequentialFile stage with option "number of readers" set to 2. This data goes to a Transformer stage and then is written to a dataset using the DataSet stage. The default configuration file has three nodes. The environment variable $APT_DISABLE_COMBINATION is set to "True" and partitioning is set to "Auto". How many processes will be created?

  A. 5
  B. 7
  C. 9
  D. 12
  C. 9

• Question 30:

  Which two statements are true about Transformer loop processing? (Select two)

  A. Stage variables can be referenced in loop conditions.
  B. Loop conditions are evaluated once for each input row.
  C. Loop variable expressions are executed before stage variable expressions.
  D. Loop variable expressions are executed before output link column expressions.
  B. Loop conditions are evaluated once for each input row.
  C. Loop variable expressions are executed before stage variable expressions.