InfoSphere DataStage v11.3 (C2090-424) Free Practice Test

Question 1

Which of the following is TRUE?

A. The DB2 Connector stage can have, at most, one input link

B. When runtime column propagation is enabled, you can use output mapping on a stage to rename or drop columns

C. The Modify stage can keep or drop records

D. The Copy stage can be used for implicit data type conversions

Correct Answer: B

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

Question 2

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. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage

B. Row Generator stage followed by a DB2 Connector stage

C. DB2 Connector stage followed by a DB2 Connector stage

D. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage

Correct Answer: B

Question 3

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. 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.

B. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.

C. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than 1.

D. In the file name property, provide a file name with a wildcard that matches the existing file names.

E. Provide a specific file name in the file name property.

Correct Answer: B,C

Question 4

Which statement about shared containers is TRUE?

A. A container cannot be created by selecting a group of stages and links in a job

B. A shared container is an independently compiled unit

C. A shared container can be converted to a local container

D. A local container can be converted to a shared container

Correct Answer: D

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

Question 5

Which one of the following stages requires a schema file when using Runtime Column Propagation?

A. Modify Stage

B. Transformer Stage

C. Data Set Stage

D. Sequential File Stage

Correct Answer: D

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

Question 6

Which restructure stage has a single reject link?

A. Split Vector

B. Make Subrecord

C. Column Import

D. Combine Records

Correct Answer: D

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

Question 7

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. 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.

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. A Modify Operator is inserted at run time before a Transformer stage to handle null values

Correct Answer: C

Welcome to TestSimulate

IBM InfoSphere DataStage v11.3 (C2090-424) Free Practice Test