A2090-421 by IBM Actual Free Exam Q&As

Question 1

Which three statements are true about characteristics of shared containers? (Select three)

A. Containers allow you to implement recurring logic. B. Containers allow you to provide pre-configured job design logic. C. Containers allow multiple users to access a single job. D. Containers are used to execute jobs. E. Containers are a group of stages and links.

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Question 2

Which three environment variables are used for reporting on DataStage jobs? (Select three)

A. $APT_PM_PLAYER_MEMORY B. $APT_PM_STARTUP_CONCURRENCY C. $APT_DISABLE_ROOT_FORKJOIN D. $APT_DUMP_SCORE E. $OSH_PRINT_SCHEMAS

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 3

In which two operations can you create DataStage projects? (Choose two.)

A. When exporting and importing a DataStage project from DataStage Director. B. When adding new projects from DataStage Administrator. C. When creating a project in the IBM Information Server Console. D. During DataStage installation.

Discussion 0

Correct Answer: B,D Vote an answer

Question 4

Which two statements about annotations are correct? (Select two)

A. The Full job description field is only visible within the Designer Client. B. The Short job description field displays on log summary lines within Director client. C. An annotation can be drawn around one of more stages. D. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.

Discussion 0

Correct Answer: C,D Vote an answer

Question 5

You are asked to convert a relational source, as shown in the exhibit, into three separate XML files. How would you accomplish this task?

A. Set "Output mode" setting "Break" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage. B. Set "Output mode" setting "Segregate" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage. C. Set "Output mode" setting" Split rows" under "Transformation Settings" of the Output link of an XML Output stage. D. Set "Output mode" setting "Single row" under "Transformation Settings" of the Output link of an XML Output stage.

Discussion 0

Correct Answer: D Vote an answer

Question 6

What stage allows for more than one reject link?

A. Join stage B. Funnel stage C. Peek stage D. Lookup stage E. Merge stage

Discussion 0

Correct Answer: E Vote an answer

Question 7

Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)

A. Define the connection properties to an ODBC data source. B. Define columns for the output link. C. Specify the remote server property. D. Specify properties for the input link.

Discussion 0

Correct Answer: A,D Vote an answer

Question 8

A dataset was created earlier with one partition, with the Preserve Partitioning flag set. A subsequent job using a 2-node configuration file reads from that dataset, passing data to a Transformer stage with "Same" partitioning.
Which two statements are true? (Select two)

A. Inserting a Sort stage prior to the Transformer stage will force its parallel execution. B. Setting the Preserve Partitioning flag to "Clear" will generate two instances of the Transformer stage. C. Setting the Preserve Partitioning flag to "Set" will run one instance of the Transformer stage. D. DataStage will repartition the data and run one instance of the Transformer stage. E. The DataStage job will abort.

Discussion 0

Correct Answer: B,D Vote an answer

Question 9

Where are project level message handlers defined?

A. DSENV B. Designer Client C. Director Client D. Administrator Client

Discussion 0

Correct Answer: D Vote an answer

IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 Exam Practice Test