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.

Given this score:

It runs 3 processes on 2 nodes. How does the job run?

A. On two physical nodes and two logical nodes

B. On two physical nodes and single logical node

C. On a single physical node and two logical nodes

D. On a single physical node and single logical node

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

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

What COBOL data type is defined by Decimal data within the Complex Flat File stage?

A. COMP

B. COMP-1

C. COMP-2

D. COMP-3

Which of the following locations will allow you to obtain a job's runtime logs? (Choose two.)

A. Designer

B. ISManager

C. Workload Manager

D. Operations Console

E. Performance Monitor

Which Slowly Changing Dimension (SCD) stage statement is TRUE?

A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database

B. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching

C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.

D. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link

Select the correct command to reset a password to Info1234 for user srv_etl in the Information Server internal registry, in the Unix environment.

A. iisAdmin.sh –user srv_etl –password Info1234

B. iisAdmin.sh –user –userid srv_etl –password Info1234

C. SessionAdmin.sh –user –userid srv_etl –password Info1234

D. DirectoryAdmin.sh –user –userid srv_etl –password Info1234