C2090-424 Online Practice Questions and Answers

Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?

A. Difference

B. Change Apply

C. Change Capture

D. Change Capture and Change Apply

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

A. Data Set

B. Column Import

C. Internal Source

D. External Target

E. Make Subrecord

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. Provide a specific file name in the file name property.

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

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. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.

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

Which statement about the ISD input stage is NOT TRUE?

A. A job must have zero or one ISD input stages

B. A job with an ISD input stage must have an ISD output stage

C. Buffer size and timeout values can be supplied as job parameters

D. Text over JMS binding is only available if you are using Network Deployment

How do you create a shared table definition from the DataStage client?

A. Use the save button on the columns tab of the stage editor

B. Use the shared table creation wizard from the repository window

C. Do nothing. They are created automatically when table definitions are imported

D. It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.

You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job.

What steps should you take to understand the job performance issues? (Choose two.)

A. Use the resource estimation tool

B. Use the performance analysis tool

C. Replace Join stages by Lookup stages

D. Run the job with $APT_TRACE_RUN set to true

E. Run the job with $APT_DUMP_SCORE set to true

Which of the following statements about checkpoint/restart is TRUE?

A. The parallel framework does not support checkpoints inside jobs

B. You must set the environment variable $APT_DISABLE_COMBINATION to TRUE

C. To perform checkpoint inside a parallel job, select the checkpoint option in each stage

D. If the checkpoint/restart is turned on for a sequence job, all components of this sequence job must perform checkpoint recording

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

A. record (tField:time[hour:minute:second];)

B. record (tField:nullable time[];)

C. record (tField:time[seconds];)

D. record (tField:time[microseconds];)

A job is designed with 3 Join stages in sequence.

Join_1 keys are "Account", "Customer" and "PO_Date"

Join_2 keys are "Account", "Customer" and "Txn"

Join_3 keys are "Account", "Product_CD" and "Txn"

Which of the following will lead to the best run time performance?

A. Left links are Hash partitioned on "Account" for all joins Right links are Hash partitioned on "Account" for all joins

B. Both left and right links are Hash partitioned as follows: Join_1 by "Account", "Customer" and "PO_Date" Join_2 by "Account", "Customer" and "Txn" Join_3 by "Account", "Product_CD" and "Txn"

C. Both left and right links are Hash partitioned as follows: Join_1 by "Account" and "Customer" Join_2 by "Account" and "Customer" Join_3 by "Account"

D. Left links are Hash partitioned on "Account" for the first two joins and on "Product_CD" for the third. Right links are Hash partitioned on "Account" for all joins

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

A. Secure sensitive personal data

B. To set up credentials files used by the dsjob command

C. Assisting in decoding encrypted rows of input during debugging

D. Assisting in preparing encrypted rows of output during job execution