C2090-424 Exam Training Practice Tests (IBM InfoSphere DataStage v11.3)]

Question 1

Which of the following is the correct schema format for a Time column?

A. record (tField:time[hour:minute:second];) B. record (tField:time[microseconds];) C. record (tField:nullable time[];) D. record (tField:time[seconds];)

Correct Answer: D

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

Question 2

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

A. Modify B. Difference C. Join D. Funnel E. Merge

Correct Answer: C,E

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

Question 3

In the Masking Policy Editor in the Data Masking stage of your job, you have specified for a column containing credit card numbers the Random Replacement masking policy. For the Copy option you have specified "(1,2)(3,4)".
What changes will be made to a credit card number, such as 6327664369, to mask it?

A. Digits 1 through 2 and digits 3 through 4 will be randomly changed. The rest of the digits will remain the same. B. The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will be randomly changed. The rest of the digits will remain the same. C. Digits 1 through 2 and digits 3 through 4 will remain the same. The rest of the digits will be randomly changed. D. The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will remain the same. The rest of the digits will be randomly changed.

Correct Answer: B

Question 4

Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1 for the user srv_etl?

A. dsjob -domain is1:9445 -server is1 -user srv_etl -password {iisenc} QHw0Q6i1zBuHhM3HcHPQrw= = -run dstage1 jTest101 B. dsjob -domain is1:9445 -server is1 -userid srv_etl -password {iisenc}infosphere -run dstage1 jTest101 C. dsjob -domain is1:9445 -server is1 -username srv_etl -password iisenc_infosphere -run dstage1 jTest101 D. dsjob -domain is1:9445 -server is1 -user srv_etl -run dstage1 jTest101

Correct Answer: B

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

Question 5

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

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

Correct Answer: D

Question 6

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

A. Internal Source B. Column Import C. Data Set D. External Target E. Make Subrecord

Correct Answer: B,D

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

Question 7

Which of the following statements about real time job design is TRUE?

A. The Information Services Director server starts job instances on one or more DataStage servers for load balancing and scalability. B. A DataStage job must have an ISD Input stage, but an ISD Output stage is not required. C. DSJobInvocationId is not required for the target sequential file. D. A non-Multiple Instance DataStage job can be activated for ISD service.

Correct Answer: A

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

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