IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 11:

  Which two statements about using a Load write method in an Oracle Connector stage to tables that have indexes on them are true? (Choose two.)

  A. Set the Upsert mode property to "Index".
  B. Set the Index mode property to "Bypass".
  C. The Load Write method uses the Parallel Direct Path load method.
  D. The Load Write method uses "Rebuild" mode with no logging automatically.
  E. Set the environment variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)".
  C. The Load Write method uses the Parallel Direct Path load method.
  E. Set the environment variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)".

• Question 12:

  You want to better understand the tsort operators that are inserted into the job flow at runtime. Which environment variable can provide this information?

  A. $OSH_DUMP
  B. $APT_DUMP_SCORE
  C. $APT_STARTUP_STATUS
  D. $APT_PM_PLAYER_MEMORY
  B. $APT_DUMP_SCORE

• Question 13:

  A customer must compare a date column with a job parameter date to determine which output links the row belongs on.

  What stage should be used for this requirement?

  A. Filter stage
  B. Switch stage
  C. Compare stage
  D. Transformer stage
  D. Transformer stage

• Question 14:

  In the Slowly Changing Dimension stage, a dimension columns Purpose code property can trigger which two actions. (Choose two.)

  A. Update fact table keys.
  B. Detect dimension changes.
  C. Update the dimension table.
  D. Insert rows into the fact table.
  E. Delete duplicate dimension table rows.
  B. Detect dimension changes.
  C. Update the dimension table.

• Question 15:

  Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

  A. Split Vector
  B. Column Import
  C. Split Subrecord
  D. Merge records
  E. Make Subrecord
  C. Split Subrecord
  E. Make Subrecord

• Question 16:

  Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)

  A. XML Stages are Plug-in stages.
  B. XML Stage can be found in the Database folder on the palette.
  C. Uses a unique custom GUI interface called the Assembly Editor.
  D. It includes the XML Input, XML Output, and XML Transformer stages.
  E. A single XML Stage, which can be used as a source, target, or transformation.
  C. Uses a unique custom GUI interface called the Assembly Editor.
  E. A single XML Stage, which can be used as a source, target, or transformation.

• Question 17:

  Which two commands start a DataStage job named procRows in a project named DSProject. It also passes the value 200 to the numRows parameter. (Choose two.)

  A. dsjob -run -paramfile numRows=200 DSProject procRows
  B. dsjob -run -mode normal -param numRows=200 DSProject procRows
  C. dsjob -run -mode validate -param numRows=200 DSProject procRows
  D. dsjob -run -mode normal -paramfile numRows=200 DSProject procRows
  E. dsjob -run -queue HighPriority -param numRows=200 DSProject procRows
  B. dsjob -run -mode normal -param numRows=200 DSProject procRows
  E. dsjob -run -queue HighPriority -param numRows=200 DSProject procRows

• Question 18:

  What two computer system resources on the DataStage engine are monitored in the Operations Console? (Choose two.)

  A. Disk
  B. CPU
  C. Memory
  D. Scratch disk
  E. XMETA database
  B. CPU
  C. Memory

• Question 19:

  Modular development techniques should be used to maximize re-use of DataStage jobs and components. Which statement represents Modular Development techniques?

  A. Job parameters should be used in Job Names.
  B. Hard code the Invocation ID to improve development process.
  C. Create a standard directory structure inside of the DataStage project directory for source and target files.
  D. Job parameterization allows a single job design to process similar logic instead of creating multiple copies of the same job.
  D. Job parameterization allows a single job design to process similar logic instead of creating multiple copies of the same job.

• Question 20:

  You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which technique will enable you to retrieve the sum of the last group?

  A. Output the sum that you generated each time you process a row for which the LastRow() function returns True.
  B. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.
  C. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.
  D. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the FirstRow() function to determine when the group is done.
  C. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.