C2090-424 Online Practice Questions and Answers

Which of the following is TRUE when using a data set created with a 4 node config file?

A. Data sets are operating system files

B. Data is stored in a non-persistent form

C. The data set control file holds all your data

D. A Data Set stage can have 1 input link and multiple output links

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.

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

A. Predicates cannot refine what rows are updated

B. Table(s) referenced must have table definitions imported previously

C. Column values can be job parameters or input columns but not expressions

D. Columns to update must be selected individually from the column selection grid

Record Count property is set to zero in Connector stage. How many rows are written out?

A. All Rows

B. One Row

C. Zero Rows

D. 2000 Rows

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

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

A. Modify Stage

B. Data Set Stage

C. Transformer Stage

D. Sequential File Stage

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_MONITOR_SIZE

B. $APT_RECORD_COUNTS

C. $APT_DISABLE_COMBINATION

D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE