C2090-424 InfoSphere DataStage v11.3

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which stages will require a schema file when runtime column propagation (RCP) is enabled?

(Choose two.)

Select all that apply, then click Submit answer.

  • Data Set

  • Column Import

  • Internal Source

  • External Target

  • Make Subrecord

Question 5

Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named “highperfnodes” that includes only nodes with very high processing power.

What additional design changes do you need to make to the job to ensure that it aggregates the data using the “highperfnodes” pool? (Choose two.)

Select all that apply, then click Submit answer.

  • Select the “highperfnodes” pool in the Execution tab of the Job Properties window

  • Add the $APT_CONFIG_FILE environment variable as an additional job parameter

  • Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated

  • Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool

  • Change properties in the Aggregator stage to force it to use the new non-default configuration file

Question 6

The encrypt.sh or the encrypt.bat script can be used to do which of the following?

Select an option, then click Submit answer.

  • Secure sensitive personal data

  • To set up credentials files used by the dsjob command

  • Assisting in decoding encrypted rows of input during debugging

  • Assisting in preparing encrypted rows of output during job execution