IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 81:

  Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a single existing table on a remote database. You are using Run-Time Column Propagation (RCP) on all of the links. Which two job design configuration actions would you consider to effectively use RCP? (Select two)

  A. In the DB2 Enterprise stage use Connection properties to manage column mappings.
  B. In the DB2 Enterprise stage set the option named "Silently Drop Columns Not in Table" to "True".
  C. Use a Modify stage prior to the DB2 Enterprise stage in order to drop the columns not found in the table.
  D. Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column layout in partitions.
  B. In the DB2 Enterprise stage set the option named "Silently Drop Columns Not in Table" to "True".
  D. Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column layout in partitions.

• Question 82:

  Which three statements are true about stage variables in a Transformer Stage? (Choose three.)

  A. Stage variables can be set to NULL.
  B. Varchar stage variables can be initialized with spaces.
  C. Stage variables are refreshed with default values before each new input row is processed.
  D. The expression executed for a stage variable can refer to a stage variable which is executed later.
  E. A stage variable in one Transformer can refer to a stage variable in another Transformer,as long as the second Transformer was processed earlier in the job flow.
  A. Stage variables can be set to NULL.
  B. Varchar stage variables can be initialized with spaces.
  D. The expression executed for a stage variable can refer to a stage variable which is executed later.

• Question 83:

  What Information Server tool provides integration with source code control repositories?

  A. DataStage Designer
  B. Multiple Job Compile
  C. Information Server Manager
  D. Information Services Director
  C. Information Server Manager

• Question 84:

  You are describing to your customer how to work with packages. There are two steps that must be carried out in order to move the package to a target project. Which two steps must be carried out to move the DataStage objects to the Production system? (Choose two.)

  A. Build
  B. Export
  C. Deploy
  D. Package
  E. Compile
  A. Build
  C. Deploy

• Question 85:

  You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job. What are the first two steps you should take to understand the job performance issues? (Choose two.)

  A. Review the objectives of the job.
  B. Run job with $APT_TRACE_RUN set to true.
  C. Run job with $APT_DUMP_SCORE set to true.
  D. Replace Transformer stages with custom operators.
  A. Review the objectives of the job.
  C. Run job with $APT_DUMP_SCORE set to true.

• Question 86:

  You have a DataStage job on SMP environment. It contains an input sequential file, a Modify stage, followed by a Transformer stage, and an output Sequential File stage. The job is run with three nodes. The engine uses all default settings. How many processes will this job create?

  A. 9
  B. 12
  C. 16
  D. 19
  A. 9

• Question 87:

  If you do not alter any of the Format settings, the Sequential File stage will produce a file with what three types of format? (Choose three.)

  A. Rows are delimited by a DOS newline.
  B. Rows are delimited by a UNIX newline.
  C. All columns are delimited by a comma.
  D. Variable length columns are contained within double quotes.
  E. All columns are delimited by a comma,except for the final column in a row.
  B. Rows are delimited by a UNIX newline.
  D. Variable length columns are contained within double quotes.
  E. All columns are delimited by a comma,except for the final column in a row.

• Question 88:

  Which of the following describes a type two update in a Slowly Changing Dimensions (SCD) stage?

  A. An update that overwrites the existing column value.
  B. An update that replaces the existing column value if a specified condition is satisfied.
  C. An update that retains the existing column value in a list and adds the new value to the list.
  D. An update the retains the existing column value in an historical row and creates a new row with the new value.
  C. An update that retains the existing column value in a list and adds the new value to the list.

• Question 89:

  Which two statements are true about the use of named node pools? (Choose two.)

  A. Named node pools can allow separation of buffering from sorting disks.
  B. Clustered environments must have named node pools for data processing.
  C. Using appropriately named node pools forces DataStage to use named pipes between stages.
  D. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools.
  A. Named node pools can allow separation of buffering from sorting disks.
  D. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools.

• Question 90:

  In which two operations can you create DataStage projects? (Choose two.)

  A. During DataStage installation.
  B. When adding new projects from DataStage Administrator.
  C. When creating a project in the IBM Information Server Console.
  D. When exporting and importing a DataStage project from DataStage Director.
  A. During DataStage installation.
  B. When adding new projects from DataStage Administrator.