Assessment: IBM InfoSphere DataStage v9.1 Assessment (A2090-303) Free Practice Test

Question 1

On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?

A. diffapicmdline.exe

B. Cross Project Compare

C. Compare Against

D. DSMakeJobReport

Correct Answer: B

Question 2

The parallel framework was extended for real-time applications. Identify two of these aspects. (Choose two.)

A. Real-time stage types that keep jobs always up and running.

B. End-of-wave.

C. Support for transactions within source database connector stages.

D. Real-time stage types that re-run jobs.

E. XML stage.

Correct Answer: A,B

Question 3

Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

A. Generate unique file names by using a macro.

B. Use a Transformer stage variable to generate the name.

C. Use parameters to identify file names.

D. Use DSJoblnvocationID to generate a unique filename.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Which statement is true about Information Server logging?

A. You can activate or de-activate the logging configuration in DataStage Administrator.

B. You must log into the Information Server Web Console as a DataStage administrator in order to configure logging.

C. Multiple configurations can be active at the same time.

D. Severity levels specify the threshold for saving events in the metadata repository.

Correct Answer: D

Question 5

Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)

A. Group stage

B. Wrapped stage

C. Basic stage

D. Input stage

E. Custom stage

Correct Answer: B,E

Question 6

A job using a three-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to two different sequential files. How many instances of the Sequential File stage will run?

A. Three instances.

B. Four instances.

C. Two instances.

D. One instance.

Correct Answer: C

Question 7

Which statement is correct about the Data Rules stage?

A. If you have Rule Creator role in InfoSphere Information Analyzer, you can create and publish rule definitions and rule set definitions directly from the stage itself.

B. As a best practice, you should create and publish new rules from the Data Rules stage.

C. When a job that uses the Data Rules stage runs, the output of the stage is passed to the downstream stages and results are stored in the Analysis Results database (IADB).

D. The Data Rules stage works with rule definitions only; not executable rules.

Correct Answer: D

Question 8

What two features distinguish the Operations Console from the Director job log? (Choose two.)

A. Jobs can be started and stopped in Director, but not in the Operations Console.

B. Workload management is supported within Director, but not in the Operations Console.

C. The Operations Console can run on systems where the DataStage clients are not installed.

D. The Operations Console can monitor jobs running on more than one DataStage engine.

E. The Operations Console can monitor jobs running on only one DataStage engine.

Correct Answer: C,D

Question 9

What role must a user have to delete shared metadata assets from the repository?

A. Information Analyzer Administrator

B. DataStage Administrator

C. Business Glossary Administrator

D. Common Metadata Administrator

Correct Answer: D

Question 10

When optimizing a job, Balanced Optimization will NOT search the job for what pattern?

A. Property Settings

B. Stages

C. Links

D. Sequencers

Correct Answer: D

Welcome to TestSimulate

IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment (A2090-303) Free Practice Test