A2090-303 by IBM Valid Free Exam Practice Test

Question 1

Which two actions are available when editing a message handler? (Choose two.)

A. Suppress from the project B. Demote to informational C. Suppress from job log D. Abort job E. Demote to warning

Correct Answer: B,C

Question 2

You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?

A. Indicate all stage names within the job annotation. B. Name all stage and links with column names and ideas. C. Name all stages and links based on what they do. D. Name all stage and links the same.

Correct Answer: C

Question 3

Which statement is correct about the Data Rules stage?

A. As a best practice, you should create and publish new rules from the Data Rules stage. B. The Data Rules stage works with rule definitions only; not executable rules. C. 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. D. 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).

Correct Answer: B

Question 4

You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are two valid ways to do this? (Choose two.)

A. Check the "Propagate Parameters" checkbox in the Sequence Job properties. B. Use the UserVariablesActivity stage to populate the local parameters from an outside source such as a file. C. Use local parameters. D. Add a Transformer stage variable to the job sequence canvas. E. Place a parameter set stage on the job sequence.

Correct Answer: B,C

Question 5

Which two statements are true about stage variables in a Transformer Stage? (Choose two.)

A. A stage variable in one Transformer can refer to a stage variable in another Transformer, as long as the second Transformer was processed earlier in the job flow. B. Stage variables can be set to NULL. C. Varchar stage variables can be initialized with spaces. D. Stage variables are refreshed with default values before each new input row is processed. E. Stage variables cannot be set to NULL.

Correct Answer: B,C

Question 6

What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)

A. TFTP B. RFTP C. FTP D. EFTP E. SFTP

Correct Answer: C,E

Question 7

Click the Exhibit button.

The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

A. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports. B. Designer Performance Analyzer tool. C. Director job monitor tool. D. The view data button in the target Connector stage. E. Designer "Show performance statistics" option.

Correct Answer: C,E

IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment - A2090-303 Exam Practice Test