IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 81:

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

  A. Stage variables can be set to NULL.
  B. Stage variables cannot be set to NULL.
  C. Varchar stage variables can be initialized with spaces.
  D. Stage variables are refreshed with default values before each new input row is processed.
  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.
  C. Varchar stage variables can be initialized with spaces.

• Question 82:

  A 100MB input dataset has even distribution across 400 unique key values.

  When you run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Choose two.)

  A. Convert all numeric fields to varchars.
  B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.
  C. Alter the Sort stage properties to perform a stable sort.
  D. Specify Round Robin partitioning on the input link to the Sort stage.
  E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.
  B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.
  E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.

• Question 83:

  You are editing the configuration file. Which statement is true about file system efficiency?

  A. Using multiple scratch spaces in a logical node improves performance.
  B. For the resource disk, it is best to use the partition where the engine is installed.
  C. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance.
  D. In a clustered environment where NAS is used for a common storage, you must specify the internal disk for scratch disk.
  C. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance.

• Question 84:

  You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.

  What are two requirements on the input link data for the Change Capture stage? (Choose two.)

  A. sorted
  B. merged links
  C. parallel mode
  D. key partitioned
  E. sequential mode
  A. sorted
  D. key partitioned

• Question 85:

  A job using a one-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to three different sequential files. How many instances of the Sequential File stage will run in parallel?

  A. One.
  B. Two.
  C. Three.
  D. The job will abort, because a configuration file with at least three nodes is required.
  C. Three.

• Question 86:

  What two Information Server tools can be used to create deployment packages for DataStage jobs? (Choose two.)

  A. istool
  B. Information Server Console
  C. Information Server Manager
  D. InfoSphere Metadata Assset Manager
  E. Information Server Web Console - Administration tab
  A. istool
  C. Information Server Manager

• Question 87:

  How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?

  A. Each element of the OCCURS clause is treated as a subrecord.
  B. The CFF stage cannot process COBOL files with OCCURS clauses.
  C. Each element of the OCCURS clause is treated as a column of raw data.
  D. Each element of the OCCURS clause is treated as a separate element in an array.
  D. Each element of the OCCURS clause is treated as a separate element in an array.

• Question 88:

  You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are two valid ways to do this? (Choose two.)

  A. Use local parameters.
  B. Place a parameter set stage on the job sequence.
  C. Add a Transformer stage variable to the job sequence canvas.
  D. Check the "Propagate Parameters" checkbox in the Sequence Job properties.
  E. Use the UserVariablesActivity stage to populate the local parameters from an outside source such as a file.
  A. Use local parameters.
  E. Use the UserVariablesActivity stage to populate the local parameters from an outside source such as a file.

• Question 89:

  Which two actions are available when editing a message handler? (Choose two.)

  A. Abort job
  B. Demote to warning
  C. Suppress from job log
  D. Demote to informational
  E. Suppress from the project
  C. Suppress from job log
  D. Demote to informational

• Question 90:

  You would like to run a particular processing job within a job sequence for each weekday.

  What two methods could be used? (Choose two.)

  A. Set the frequency property in the job scheduler to weekdays only.
  B. Add the job scheduler stage to the job sequence and set to weekdays only.
  C. Call a routine in the job sequencer that starts the processing job for each day you would like to process.
  D. Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.
  E. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.
  C. Call a routine in the job sequencer that starts the processing job for each day you would like to process.
  E. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.