C2090-424 by IBM Valid Free Exam Practice Test

Question 1

Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
Push processing to data sources
Push processing to data targets
The following two Balanced Optimizer options have NOT been selected:
Push data reduction processing to data targets
Push all processing into the (target) data server
Assuming the job design allows for maximum optimization, what does the optimized job design look like?

A. Row Generator stage followed by a DB2 Connector stage B. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage C. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage D. DB2 Connector stage followed by a DB2 Connector stage

Correct Answer: A

Question 2

Which type of data can be extracted using the Unstructured Data stage?

A. Microsoft Word data B. BigInsights HDFS file data C. Microsoft Excel data D. XML data

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:

A. $APT_DISABLE_COMBINATION B. $APT_RECORD_COUNTS C. $APT_MONITOR_SIZE D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE

Correct Answer: D

Question 4

To run multiple copies of the same job within Director, which of the following must be supplied?

A. Username and password B. Parameter values C. Invocation ID D. Job name

Correct Answer: B

Question 5

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

A. Assisting in decoding encrypted rows of input during debugging B. To set up credentials files used by the dsjob command C. Assisting in preparing encrypted rows of output during job execution D. Secure sensitive personal data

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

A. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column will be calculated ignoring the Null value. B. A Modify Operator is inserted at run time before a Transformer stage to handle null values C. If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected D. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null.

Correct Answer: C

Question 7

Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)

A. In the file name property, provide a file name with a wildcard that matches the existing file names. B. Set the read method with a file pattern and provide a file name with a wildcard that matches the existing file names in the file pattern property. C. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property. D. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than 1. E. Provide a specific file name in the file name property.

Correct Answer: C,D

IBM InfoSphere DataStage v11.3 - C2090-424 Exam Practice Test