IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 1:

  In a Transformer, which two of the following mappings can be handled by default type conversions.

  (Select two)

  A. Integer input column mapped to raw output column.
  B. Date input column mapped to a string output column.
  C. String input column mapped to a data output column.
  D. String input column mapped to integer output column.
  E. Integer input column mapped to string output column.
  C. String input column mapped to a data output column.
  E. Integer input column mapped to string output column.

• Question 2:

  In a Transformer Stage you have a nullable input column that is mapped to a non-nullable output column. What two techniques can be used to handle NULL values? (Choose two.)

  A. NullToValue(input_column,'unknown').
  B. IF input_column = '' THEN 'unknown' ELSE input_column.
  C. IF input_column = NULL THEN 'unknown' ELSE input_column.
  D. IF IsNULL(input_column) THEN 'unknown' ELSE input_column.
  A. NullToValue(input_column,'unknown').
  D. IF IsNULL(input_column) THEN 'unknown' ELSE input_column.

• Question 3:

  In a Transformer expression for a stage variable, there is a nullable input column. What happens when a row is processed that contains NULL in that input column?

  A. The job aborts.
  B. The row is rejected.
  C. NULL is written to the stage variable.
  D. The value written to the stage variable is undetermined.
  C. NULL is written to the stage variable.

• Question 4:

  To better understand the data flowing through a job, it is desirable to have structural information about the datasets captured in the job log. Which environment variable can provide this information?

  A. $OSH_STDOUT_MSG
  B. $OSH_PRINT_SCHEMAS
  C. $APT_PM_PLAYER_MEMORY
  D. $APT_NO_PART_INSERTION
  B. $OSH_PRINT_SCHEMAS

• Question 5:

  Which three statements are true about File Sets? (Choose three.)

  A. File sets are partitioned.
  B. File sets are readable by external applications.
  C. File sets always execute in parallel.
  D. File sets are stored as header file and data files.
  E. File sets have a proprietary data format which may change in future DataStage versions.
  A. File sets are partitioned.
  B. File sets are readable by external applications.
  D. File sets are stored as header file and data files.

• Question 6:

  Which two statements are correct when using the Oracle Enterprise stage? (Choose two.)

  A. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH.
  B. Define variable $TNS_ADMIN to point to the tnsnames.ora file location.
  C. DataStage Designer requires connectivity to the Oracle database during job development.
  D. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH,or $SHLIB_PATH.
  A. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH.
  D. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH,or $SHLIB_PATH.

• Question 7:

  When using Runtime Column Propagation, which three stages require a schema file? (Select three)

  A. Peek stage
  B. File Set stage
  C. Column Import stage
  D. DB2 Enterprise stage
  E. Sequential File stage
  B. File Set stage
  C. Column Import stage
  E. Sequential File stage

• Question 8:

  Which three of the following are valid options for the dsjob command? (Choose three.)

  A. Stopping a job
  B. Compiling a job
  C. Purging log files
  D. Accessing log files
  E. Setting an alias for a job
  A. Stopping a job
  D. Accessing log files
  E. Setting an alias for a job

• Question 9:

  A job is using the Load method in the DB2 and Oracle Enterprise stage for parallel loading into a single table. The job fails at runtime and you see there are new table rows added. What would explain this result? (Select two) A. Load operations are parallel.

  B. Load operations are sequential.
  C. Commit size is smaller than source data.
  D. Some partitions completed before failure.
  C. Commit size is smaller than source data.

• Question 10:

  You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables.You set environment variable $APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables. Which statement is accurate regarding the resulting effect of this environment variable setting?

  A. Oracle load will fail when executed.
  B. Oracle load will run in parallel and bypass DataStage Director.
  C. The Oracle load will run in parallel using simple direct path mode.
  D. The Oracle database stage will run in parallel using conventional path mode.
  A. Oracle load will fail when executed.