IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 131:

  You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by a former developer of the project. How can you find these jobs?

  A. Sort the jobs by date in the Repository window.
  B. Use Advanced Find feature in the Designer interface.
  C. Select the top project folder and choose Find Dependencies (deep).
  D. Right-click on jobs folder in the Repository window and select Filter jobs.
  B. Use Advanced Find feature in the Designer interface.

• Question 132:

  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
  C. Output column derivations

• Question 133:

  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.
  A. Enable Run Time Column propagation.
  D. Configure the Schema File property with the path of the schema file definition.

• Question 134:

  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
  C. Stage variable derivations

• Question 135:

  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.
  A. A JAQL stage is found in the optimized job result.
  C. A Balanced Optimization parameter set is found in the project

• Question 136:

  Which two statements are true about Data Sets? (Choose two.)

  A. Data sets contain ASCII data.
  B. Data Sets preserve partitioning.
  C. Data Sets require repartitioning.
  D. Data Sets represent persistent data.
  E. Data Sets require import/export conversions.
  B. Data Sets preserve partitioning.
  D. Data Sets represent persistent data.

• Question 137:

  What stage allows for more than one reject link?

  A. Join stage
  B. Merge stage
  C. Lookup stage
  D. Funnel stage
  B. Merge stage

• Question 138:

  When using the Column Export stage, what are two export column type property values allowed for the combined single output column result? (Choose two.)

  A. Vector
  B. Binary
  C. Integer
  D. Decimal
  E. VarChar
  B. Binary
  E. VarChar

• Question 139:

  You have created three parallel jobs (Job A, B and C) in which the output of one job is the input to the other job. You are required to create processing that manages this data relationship of the jobs and provide job level restart-ability. What two tasks will accomplish these objectives? (Choose two.)

  A. Enable runtime column propagation for the job sequence running the jobs.
  B. Set the 'Add checkpoints so sequence is restartable' option in the Sequencer job.
  C. Enable the 'Add checkpoints so container is restartable' option for each of the parallel shared containers.
  D. Create two parallel shared containers that has the logic of Job B and Job C and include those shared containers in the correct flow order within the design of Job A.
  E. Create a Sequencer job that has triggered events configured allowing Job A to run first, then Job B to run when A completes successfully, and then Job C to run when Job B completes successfully.
  B. Set the 'Add checkpoints so sequence is restartable' option in the Sequencer job.
  E. Create a Sequencer job that has triggered events configured allowing Job A to run first, then Job B to run when A completes successfully, and then Job C to run when Job B completes successfully.