A Job Sequence CANNOT contain __________.

A. Transformer Stages

B. Sequencer Stages

C. Triggers

D. Job Activity Stages

What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?

A. Stage reports an error

B. Stage skips the input record

C. Stage rejects the Input record

D. Job gets aborted

With Information Services Director, you can deploy services that package the following information provider types:

I.DataStage and QualityStage jobs II.SOAP over HTTP III.DB2 and Oracle SQL statements IV.Federation Server queries

A. I, II, IV

B. II, III, IV

C. I, II, III

D. I, III, IV

Which of the following stages is NOT a file data access stage?

A. Sequential File Stage

B. Transformer Stage

C. Dataset Stage

D. FileSet Stage

Which of the following statements about InfoSphere Data Architect is correct?

A. You CANNOT create a logical model from a physical model

B. InfoSphere Data Architect can deploy physical data models directly to the database management system

C. Reverse engineering data models only works for DB2 databases

D. InfoSphere Data Architect is installed using the Information Server installation wizard

Which of the following is NOT a valid File Update Mode property setting of a Sequential File Stage?

A. Append

B. Overwrite

C. Delete

D. Create

Which of the following statements is not a supported matching option of the Lookup Stage?

A. Equality match

B. Caseless match

C. Range on the Target Link

D. Range on the Reference Link

What is a descriptor file of a Dataset created by the Dataset Stage?

A. Contains the length of the data files

B. Contains metadata, data location, but not the data itself

C. Contains the actual data in text format

D. Contains the actual data in binary format

Which of the following is a standard practice when using partition parallelism?

A. Disable the pipeline parallelism for all the stages that can run in parallel

B. Setup a configuration file defining multiple CPUs for each logical node

C. Avoid repartitioning if possible

D. All of the above

A DataStage job can be executed from_______________

A. DataStage Administrator client only

B. DataStage Administrator or Director client

C. DataStage Director client only

D. DataStage Designer or Director client.