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

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. Digits 1 through 2 and digits 3 through 4 will remain the same. The rest of the digits will be randomly changed.

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

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

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 of the following is NOT TRUE about the DataStage job score?

A. It includes the operators automatically inserted at runtime

B. It helps to determine the number of actual operating system processes

C. It reports the amount of memory used by the inter-operator transport buffers

D. It outlines the connection topology between adjacent operators and persistent data sets

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 is NOT a valid native operator for OSH?

A. Sort

B. Copy

C. Import

D. Generator

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 you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?

A. Set format's fill char option using the value

B. Set string type default option using the value

C. Set format's null field value option using the value

D. Set $APT_IMPEXP_REJECT_NULLS using the value

Which client Tool is used to export environment variables from a Project?

A. InfoSphere DataStage Director

B. InfoSphere DataStage Manager

C. InfoSphere DataStage Designer

D. InfoSphere DataStage Administrator

Which of the following is NOT a valid use of stage variables?

A. Storing values to be used in both derivations and constraints

B. Storing values that can be referenced by name in downstream stages

C. Storing values from one row to compare with values in the next row read

D. Storing the result on an expression to be used in multiple output columns