IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 121:

  What are the three aggregation types can be set in the Aggregator stage? (Select three)

  A. Calculate
  B. Sum Rows
  C. Recalculate
  D. Count Rows
  E. Count Values
  A. Calculate
  C. Recalculate
  D. Count Rows

• Question 122:

  You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. By default, the Change Capture stage produces an output change link with which two characteristics? (Choose two.)

  A. added column named Change_Code
  B. added column named Difference_Value
  C. Table Definition based on the after input link
  D. Table Definition based on the keys of the input link
  A. added column named Change_Code
  C. Table Definition based on the after input link

• Question 123:

  Which two statements about annotations are correct? (Select two)

  A. An annotation can be drawn around one of more stages.
  B. The Full job description field is only visible within the Designer Client.
  C. The Short job description field displays on log summary lines within Director client.
  D. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.
  A. An annotation can be drawn around one of more stages.
  D. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.

• Question 124:

  A customer requires reading a fixed-length sequential file in parallel where input rows can be identified. What two tasks must be done to meet these requirements? (Choose two.)

  A. Set partitioning method to Same.
  B. Specify Multiple readers per node.
  C. Set $APT_READ_MULTI_NODES to TRUE.
  D. Ensure data has unique identifiers for data rows.
  B. Specify Multiple readers per node.
  D. Ensure data has unique identifiers for data rows.

• Question 125:

  What two features enable a job with a Sequential File stage to read from sequential files with different numbers of columns and types? (Select two)

  A. Vector data type
  B. Subrecord data type
  C. Schema File property
  D. Runtime Column Propagation
  B. Subrecord data type
  D. Runtime Column Propagation

• Question 126:

  Configuring the weighting column of an Aggregator stage affects which three options. (Choose three.)

  A. Sum
  B. Maximum Value
  C. Sum of Weights
  D. Corrected Sum of Squares
  E. Percent Coefficient of Variation
  A. Sum
  C. Sum of Weights
  E. Percent Coefficient of Variation

• Question 127:

  What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

  A. RCP is not a feature of DataStage.
  B. Only columns used in the data flow need to be defined.
  C. Only columns that are defined as VarChar need RCP enabled.
  D. Sequential files don't require schema files when using RCP.
  E. Columns not specifically used in the flow are propagated as if they were.
  B. Only columns used in the data flow need to be defined.
  E. Columns not specifically used in the flow are propagated as if they were.

• Question 128:

  You have finished changes to many Jobs and Shared containers. You must export all of your changes and integrate them into a test project with other objects. What are two ways to select the objects you changed for the export? (Select two) A. Sort the jobs by timestamp.

  B. Use Multiple Job Compile to locate objects that need to be compiled.
  C. Select a folder in your repository tree,right click and choose "Objects that I last modified".
  D. Using the advanced find dialog,specify in the last modified panel. the date range of the jobs and appropriate user name.
  C. Select a folder in your repository tree,right click and choose "Objects that I last modified".
  D. Using the advanced find dialog,specify in the last modified panel. the date range of the jobs and appropriate user name.

• Question 129:

  Which two statements are true about DataStage parallel routines? (Choose two.)

  A. Parallel routines are written in DataStage Basic.
  B. Parallel routines are coded within a DataStage Designer editor.
  C. Parallel routines created as shared library functions are not supported.
  D. Parallel routines can be written that are called before or after a stage runs.
  E. Parallel routines can be written that are called from within the Transformer stage.
  D. Parallel routines can be written that are called before or after a stage runs.
  E. Parallel routines can be written that are called from within the Transformer stage.

• Question 130:

  In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators to ensure the correct results.

  

  Which two choices will eliminate sort operators from being inserted at run-time? (Select two)

  A. Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the Aggregator and Join stages.
  B. Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages.
  C. Add Sort stages in front of the Join stage and specify the Same partitionerfor the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".
  D. Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable to "True".
  B. Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages.
  C. Add Sort stages in front of the Join stage and specify the Same partitionerfor the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".