IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 31:

  A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)

  A. Disable job monitoring.
  B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
  C. Unset the Preserve Partitioning flag on the output of each parallel dataset.
  D. Explicitly specify hash partitioning and sorting on each input to the Join stage.
  E. Add a parallel sort stage before each Join input,specifying the "Don't Sort,Previously Grouped" sort key mode for each key.
  B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
  E. Add a parallel sort stage before each Join input,specifying the "Don't Sort,Previously Grouped" sort key mode for each key.

• Question 32:

  A star schema data warehouse consists of four dimension tables and one fact table. How many Slowly Changing Dimensions (SCD) stages will you need in your jobs to update the star schema tables?

  A. two
  B. three
  C. four
  D. five
  C. four

• Question 33:

  A customer requires that a single output file generated by a parallel job be created in sort order. Which two job designs would achieve this goal? (Choose two.)

  A. Insert a sorted Funnel stage before the input to the output SequentialFile stage.
  B. Specify both partition and sort key columns on the input to the target SequentialFile stage.
  C. Use a parallel sort and partition the input to the SequentialFile stage using a Sort Merge collector.
  D. Set the "Execution Mode" in the Advanced stage properties tab of the parallel Sort stage to execute sequentially.
  E. Write the result to a parallel dataset,then write a shell script to convert the dataset records to text format,in sorted order.
  C. Use a parallel sort and partition the input to the SequentialFile stage using a Sort Merge collector.
  D. Set the "Execution Mode" in the Advanced stage properties tab of the parallel Sort stage to execute sequentially.

• Question 34:

  Which three of the following are valid schema formats? (Choose three.)

  A. Raw Columns
  B. Total Columns
  C. Decimal Columns
  D. Integer Columns
  E. Aggregator Columns
  A. Raw Columns
  C. Decimal Columns
  D. Integer Columns

• Question 35:

  A copy of a production job was moved into a development project and modified to improve performance. You must prepare a report for a code review that documents the changes to the job. How would you gather the information for this report? (Select two)

  A. Compare Within
  B. DSMakeJobReport
  C. diffapicmdline.exe
  D. Cross Project Compare
  B. DSMakeJobReport

• Question 36:

  Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)

  A. Sort the data on the reference link.
  B. Change the lookup option in the stage properties to "Sparse".
  C. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
  D. Establish a relationship between the key field column in the source stage with the database table field.
  B. Change the lookup option in the stage properties to "Sparse".
  D. Establish a relationship between the key field column in the source stage with the database table field.

• Question 37:

  A customer is complaining of poor performance from the job shown in the exhibit, which aggregates and joins on ZIP code. Currently all partitioning is set to "Auto" and sort/partition insertion is allowed.

  

  What would give the best performance improvement for the job?

  A. Hash partition and sort on ZIP code on the input links to the Aggregator and Join stages.
  B. Hash partition and sort on ZIP code prior to the Copy stage,and use same partitioning on the Aggregator and Join stages.
  C. Use same partitioning on all input links in the job; create the input data set by hash-partitioning its input on ZIP code.
  D. Hash partition and sort on ZIP code prior to the Copy stage and use entire partitioning on the output of the Aggregator stage.
  B. Hash partition and sort on ZIP code prior to the Copy stage,and use same partitioning on the Aggregator and Join stages.

• Question 38:

  There is a requirement to load mainframe data with array columns having redefined fields into a flat file. How can the Complex Flat File

  A. CFF does not support flattening for redefined fields.
  B. Within CFF, use the Complex File Load Option window with "Flatten all arrays" option selected. CFF will handle flattening automatically.
  C. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected. Select the array with redefine column(s) and click redefine check box option.
  D. Select the Records ID tab on the Stage page. Select a record from the Records list. Select the column (s) with the redefine from the Column list. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected.
  C. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected. Select the array with redefine column(s) and click redefine check box option.
  D. Select the Records ID tab on the Stage page. Select a record from the Records list. Select the column (s) with the redefine from the Column list. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected.

• Question 39:

  Which three of the following actions are available when editing a message handler? (Select three)

  A. Abort Job
  B. Demote to warning
  C. Promote to warning
  D. Suppress from job log
  E. Demote to informational
  C. Promote to warning
  D. Suppress from job log
  E. Demote to informational

• Question 40:

  A script invokes an update job called "UpdateKeys" via a command line invocation of the dsjob command. The service is to wait for the completion and status of this job before continuing with the rest its tasks. Which three commands would invoke the "UpdateKeys" job in the MigrationProject and wait for its completion status? (Select three)

  A. dsjob -run MigrationProject UpdateKeys
  B. dsjob-run-wait MigrationProject UpdateKeys
  C. dsjob -run -jobstatus MigrationProject UpdateKeys
  D. dsjob-run-userstatus MigrationProject UpdateKeys
  E. dsjob -run -log dsjob -run -userstatus MigrationProject UpdateKeys
  B. dsjob-run-wait MigrationProject UpdateKeys
  D. dsjob-run-userstatus MigrationProject UpdateKeys
  E. dsjob -run -log dsjob -run -userstatus MigrationProject UpdateKeys