Practice C2090-424 Exam Online

Question 1

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

Answer: C

Question 2

Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1 for the user srv_etl?

A : dsjob –domain is1:9445 –server is1 –user srv_etl –run dstage1 jTest101

B : dsjob –domain is1:9445 –server is1 –userid srv_etl –password {iisenc}infosphere –run dstage1 jTest101

C : dsjob –domain is1:9445 –server is1 –username srv_etl –password iisenc_infosphere –run dstage1 jTest101

D : dsjob –domain is1:9445 –server is1 –user srv_etl –password {iisenc} QHw0Q6i1zBuHhM3HcHPQrw= = - run dstage1 jTest101

Answer: B

Question 3

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”

Answer: D

Question 4

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

A : Join

B : Merge

C : Modify

D : Funnel

E : Difference

Answer: A,B

Question 5

Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?

A : Use the SQL type when specifying a schema via a file

B : The SQL type is what the parallel job data set understands

C : Use the Parallel tab of the Edit Column Meta Data dialog box to view the SQL type

D : The SQL type is mapped to an underlying data type that the parallel job data set understands

Answer: C

Name:	InfoSphere DataStage v11.3
Exam Code:	C2090-424
Certification:	IBM Data and AI : Data and AI
Vendor:	IBM
Total Questions:	66
Last Updated:	Apr 22, 2024

IBM C2090-424