IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 71:

  Your job will write its output to a fixed length data file.

  When configuring the sequential file stage as a target what format and column tab properties need to be considered for this type of file output?

  A. On the Output Link format tab, change the 'Delimiter' property to whitespace.
  B. On the Output Link format tab, add the 'Record Type' property to the tree and set its value to be 'F'.
  C. On the Output Link column tab, insure that all the defined column data types are fixed length types.
  D. On the Output Link column tab, specify the record size total based on all of the columns defined
  C. On the Output Link column tab, insure that all the defined column data types are fixed length types.

• Question 72:

  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
  C. Big Data File Stage
  E. Complex Flat File Stage

• Question 73:

  How must the input data set be organized for input into the Join stage? (Choose two.)

  A. Unsorted
  B. Key partitioned
  C. Hash partitioned
  D. Entire partitioned
  E. Sorted by Join key
  B. Key partitioned
  E. Sorted by Join key

• Question 74:

  A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True.

  How many player processes will this job generate?

  A. 8
  B. 10
  C. 12
  D. 16
  A. 8

• Question 75:

  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".
  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".

• Question 76:

  When using the Sequential File stage as a source, what two property options allow you to add extra columns about the file(s) you are reading onto the output link? (Choose two.)

  A. File Name Column
  B. Percent Null Column
  C. Row number Column
  D. Surrogate Key Column
  E. Number of Records Column
  A. File Name Column
  C. Row number Column

• Question 77:

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

  A. Array size
  B. Memory size
  C. Partition size
  D. Transaction size
  A. Array size

• Question 78:

  A job using a three-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to two different sequential files. How many instances of the Sequential File stage will run?

  A. One instance.
  B. Two instances.
  C. Three instances.
  D. Four instances.
  B. Two instances.

• Question 79:

  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
  D. Custom stage
  E. Wrapped stage

• Question 80:

  A job design consists of an input Sequential Files stage, a Sort stage, followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, the "Number of readers per node" property has been set to 3. The job is run on an SMP machine with a configuration file defined with 3 nodes. The $APT_DISABLE_COMBINATION variable is set to True.

  How many player processes will this job generate?

  A. 6
  B. 8
  C. 10
  D. 12
  B. 8