IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 61:

  Input rows to a Transformer contain a product name field and a field with a list of colors the product can be ordered with. The colors are separated by the pipe character (|). Here is an example of an input row:

  "Shirt"| ....| "Red, Blue, Black"|... For each input row, you want to output multiple output rows, one for each color in the list. For the above example input row, three rows are to be output, one per color: "Shirt" ... "Red", "Shirt" ... "Blue", "Shirt" ...

  "Black".

  Which three operations will you need to accomplish this? (Choose three.)

  A. Use the Count() function over the ColorList field to determine the number of loop iterations.
  B. Use the LastRowInGroup() function to determine when the last color in the color list has been processed.
  C. Use the @ITERATION variable to determine which color in the ColorList field to extract using the Field function.
  D. Specify the following loop condition: @ITERATION
  E. Use the SaveInputRecord() to save the input row for processing in the loop. Use the GetInputRecord() to extract the row for each iteration of the loop.
  A. Use the Count() function over the ColorList field to determine the number of loop iterations.
  C. Use the @ITERATION variable to determine which color in the ColorList field to extract using the Field function.
  D. Specify the following loop condition: @ITERATION

• Question 62:

  Which three parallel job stages allow you to use partial schemas? (Select three)

  A. Peek stage
  B. Dataset stage
  C. Column Import stage
  D. Sequential File stage
  E. External Source stage
  C. Column Import stage
  D. Sequential File stage
  E. External Source stage

• Question 63:

  You have a parallel shared container that is used by other parallel jobs within your project. Part of the logic in this shared container has been changed. Which two statements are true regarding this change to the parallel shared container? (Choose two.)

  A. Jobs using this parallel shared container need to be re-compiled.
  B. Use usage analysis and multi-compile to re-compile job using this shared container.
  C. You can create a sequencer to re-compile all of the routines using this shared container.
  D. Jobs using this parallel shared container need to be re-compiled only when the metadata of the container is changed.
  A. Jobs using this parallel shared container need to be re-compiled.
  B. Use usage analysis and multi-compile to re-compile job using this shared container.

• Question 64:

  You are about to begin major changes to jobs in a project. You want to conveniently identify job changes on an ad hoc basis. What two tasks will allow you to identify changes to your jobs? (Choose two.)

  A. Import the original job from a .dsx export.
  B. Select the job,then right click Compare within.
  C. Select the job,then right click Cross Project Compare.
  D. Before making a change to a job make a copy of the job in a different category folder.
  B. Select the job,then right click Compare within.
  D. Before making a change to a job make a copy of the job in a different category folder.

• Question 65:

  You have a dataset that is range-partitioned and sorted. Which technique is most efficient to create globally sorted data file?

  A. Select Ordered collector method for the input link of the final Sequential File stage.
  B. Select SortMerge collector method for the input link of the final Sequential File stage.
  C. Insert Funnel stage before the final Sequential File stage and select Sequence as Funnel Type.
  D. Insert Funnel stage before the final Sequential File stage and select Sort Funnel as Funnel Type.
  C. Insert Funnel stage before the final Sequential File stage and select Sequence as Funnel Type.

• Question 66:

  How are Host Systems added to the Shared Metadata repository? (Select two)

  A. Use the Import/Export Manager when importing shared metadata.
  B. Use the DataStage Administrator application to import new Host Systems.
  C. Use the shared table creation wizard from the DataStage client to add a new Host System.
  D. Select Repository > Metadata Sharing > Management from the main menu to open the Shared Metadata Management tool
  D. Select Repository > Metadata Sharing > Management from the main menu to open the Shared Metadata Management tool

• Question 67:

  Which three source stages require a schema file when using RCP? (Choose three.)

  A. File Set Stage
  B. Data Set Stage
  C. External Target Stage
  D. Column Export Stage
  E. Complex Flat File Stage
  A. File Set Stage
  C. External Target Stage
  D. Column Export Stage

• Question 68:

  In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a SequentialFile with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. With the Funnel stage, the funnel type is set to "Sequence". The parallel configuration file contains three nodes.

  

  How many instances of the Funnel stage run in parallel?

  A. 1
  B. 2
  C. 3
  D. 6
  C. 3

• Question 69:

  Your job runs slowly and does not scale beyond two nodes. It appears the data has been partitioned on the DoNotCall flag, which has accumulating totals based on this flag using a sort method.

  Which technique would improve scalability and performance?

  A. Increase the number of physical nodes available for partitioning.
  B. Add an additional column for partitioning to result in additional data partitions.
  C. Change the preserve partitioning option on the stage ahead of the aggregator to clear partitioning.
  D. Change the partitioning method to Round Robin; add a second Aggregator stage with Execution mode 'Sequential' and
  A. Increase the number of physical nodes available for partitioning.
  B. Add an additional column for partitioning to result in additional data partitions.

• Question 70:

  The Change Apply stage produces a change Data Set with a new column representing the code for the type of change. What are three change values identified by these code values? (Choose three.)

  A. Copy
  B. Edit
  C. Final
  D. Deleted
  E. Remove Duplicates
  A. Copy
  B. Edit
  D. Deleted