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 type of data can be extracted using the Unstructured Data stage?

A. XML data

B. Microsoft Word data

C. Microsoft Excel data

D. BigInsights HDFS file data

Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

A. Each environment must have a C++ compiler.

B. QualityStage rule sets are not a type of deployable asset.

C. It is not possible to revert to a previous version of a package.

D. A package can contain an improved version of a job which will replace the old one.

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

Which statement about looping in sequences is TRUE?

A. The Start Loop stage only supports numeric loops

B. Numeric loops must increment by one unless you supply a parameter

C. The current loop counter value can be passed to the stages in the loop

D. The compiler will insert an End Loop as the last stage in the sequence if one is omitted

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.

Which of the following is an FTP Collection method?

A. Hash

B. Same

C. Random

D. Sort Merge

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

You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?

A. Hash partition on TotalAmount. Sort on CustID, ProductType and TotalAmount

B. Hash partition on ProductType. Sort on CustID, ProductType and TotalAmount

C. Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount

D. Hash partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount

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