IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 41:

  DataStage offers database connectivity through connectors, native parallel and plug-in stage types. Which two statements are correct? (Choose two.)

  A. ODBC API is a plug-in stage.
  B. Next to the connector stage it is best to use the native parallel database stages.
  C. The connector stage offers better functionality and performance and is the best to use.
  D. For maximum parallel performance,scalability,and features it is best to use the native parallel database stages.
  B. Next to the connector stage it is best to use the native parallel database stages.
  C. The connector stage offers better functionality and performance and is the best to use.

• Question 42:

  Which statement is true about buffering?

  A. The buffer operator uses both memory and disk storage.
  B. The framework uses /tmp by default for buffering on Unix systems.
  C. In a clustered environment,using a disk space on an NFS mount for buffering improves performance.
  D. The "buffer" scratch disk pool needs to be defined to allow the framework to perform data buffering.
  A. The buffer operator uses both memory and disk storage.

• Question 43:

  Which environment variable determines where the temporary scores are stored?

  A. APT_JOB_MON
  B. APT_HIGH_SCORE
  C. APT_DUMP_SCORE
  D. APT_SAVE_SCORE
  D. APT_SAVE_SCORE

• Question 44:

  Which of the following describes what happens when Runtime Column Propagation is enabled?

  A. An input column value flows into a target column only if it matches it by name.
  B. An input column value flows into a target column only if it is explicitly mapped to it.
  C. An input column value flows into a target column based on its position in a Schema file.
  D. An input column value flows into a target column based on its position in the input row. For example,first column in the input row goes into the first target column.
  A. An input column value flows into a target column only if it matches it by name.

• Question 45:

  In the job fragment shown in the exhibit, the data going into the target Sequential File stage needs to be sorted by postal code. The Sort stage accomplishes this by running in Sequential mode and sorting by postal code. You have been asked to improve the performance of the job with a 4-node configuration file.

  

  Which two changes will improve the performance of the job? (Choose two.)

  A. Move the Sort stage in front of the Filter stage,so that the sort is performed earlier in the job.
  B. Add a second Sort stage just before the existing Sort stage; run the new stage in parallel mode sorting by postal code.
  C. Change the mode of the existing Sort stage to parallel mode; continue to sortby postal code. In the target Sequential File stage choose the SortMerge collector.
  D. Eliminate the existing Sort stage; define an in-stage sort in the Filter stage,sorting by postal code. In the target Sequential File stage choose the SortMerge collector.
  C. Change the mode of the existing Sort stage to parallel mode; continue to sortby postal code. In the target Sequential File stage choose the SortMerge collector.
  D. Eliminate the existing Sort stage; define an in-stage sort in the Filter stage,sorting by postal code. In the target Sequential File stage choose the SortMerge collector.

• Question 46:

  An important top level Job Sequence has been modified. It controls a process flow consisting of sub Job Sequences, Routines and Parallel Jobs. You must set up a new project to test the top level Job Sequence. You are not allowed to move any repository objects that are not impacted by the top level Job Sequence.

  What two options would identify only the repository objects impacted by the change made to the top level Job Sequence? (Select two)

  A. Repository Advanced Find Where Used
  B. On Export check Include dependencies of
  C. Click Impact Analysis Icon on Designer Client Toolbar.
  D. Select the top Level Job Sequence and Dependency of (deep).
  A. Repository Advanced Find Where Used
  B. On Export check Include dependencies of

• Question 47:

  Which two job design techniques can be used to provide unique names to sequential output files that are used in multi-instance jobs? (Select two)

  A. Use parameters to identify file names.
  B. Prepend/append the Invocation ID to the file name.
  C. Use the file name(s) from values contained in the data stream.
  D. Create the file name(s) from values contained in a value file.
  A. Use parameters to identify file names.
  B. Prepend/append the Invocation ID to the file name.

• Question 48:

  The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

  A. The job aborts.
  B. NULL is written to the target stage variable.
  C. The input row is either dropped or rejected depending on whether the Transformer has a reject link.
  D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.
  B. NULL is written to the target stage variable.

• Question 49:

  You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2 Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise Stage.

  What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)

  A. Type
  B. Where used
  C. Dependent upon
  D. Include Read only objects
  A. Type
  B. Where used

• Question 50:

  There is a requirement to transfer a large file using an FTP Enterprise stage. How can you minimize processing time when a transfer failure occurs?

  A. Specify restartable mode on a transfer of the single file.
  B. Manually split the file into multiple files and specify restartable mode on a transfer.
  C. Create multiple readers to transfer file data and specify restartable mode on Input link tab.
  D. Use a sequencer to check transfer status and restart the job from the beginning on failure.
  B. Manually split the file into multiple files and specify restartable mode on a transfer.