C2090-424 Online Practice Questions and Answers

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.

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 restartable sequence jobs is TRUE?

A. If a restartable sequence aborts, it can be restarted from Director.

B. Choosing "Reset job" from Director will start the job where it left off.

C. Checkpoints are always added to every eligible Job Activity stage in the sequence.

D. There is no way to force a Job Activity stage to return if the sequence got beyond it.

In order to collect operational metadata, you must do which of the following?

A. Enable "Generate operational metadata" in the Execution tab of the job properties using the Designer client

B. Enable "Generate operational metadata" in the General tab of the project properties using the Director client

C. Enable "Record job performance data" in the General tab of the project properties using the Administrator client

D. Enable "Generate operational metadata" in the General tab of the Job Run Options dialog box in the Director client

Which of the following is TRUE about working with assets and artifacts?

A. Rational Team Connect is not supported at all

B. Information Server Manager has no logging capability

C. You cannot lock and unlock assets in Rational Team Concert, regardless of tool used

D. You must import the source control project into your own source control workspace in Information Server Manager before you can submit assets

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

Which statement is TRUE?

A. The configuration file needs to be copied to all processing nodes

B. The configuration file needs to be copied to the conductor nodes and all processing nodes

C. The configuration file needs to be copied to all nodes to which the parallel engine has been configured

D. The configuration file only needs to be copied to the conductor nodes from which parallel engine applications are started

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

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

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

Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?

A. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Reports, Custom attributes for InfoSphere Information Covernance Catalog

B. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere DataStage and QualityStage assets, Reports

C. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere Data Stage and QualityStage assets

D. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Custom attributes for InfoSphere Information Governance Catalog, Reports

In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?

A. Select top level sequencer job and click on "Export" option

B. Select top level sequencer job and click on "Find dependencies" option

C. Select top level sequencer job and click on "Find dependencies (deep)" option

D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies"

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