000-421 by IBM Valid Free Exam Practice Test

Question 1

You have finished changes to many Jobs and Shared containers. You must export all of your changes and integrate them into a test project with other objects. What are two ways to select the objects you changed for the export? (Select two)

A. Using the advanced find dialog, specify in the last modified panel. the date range of the jobs and appropriate user name. B. Use Multiple Job Compile to locate objects that need to be compiled. C. Sort the jobs by timestamp. D. Select a folder in your repository tree, right click and choose "Objects that I last modified".

Correct Answer: A,D

Question 2

Which three DataStage elements allow you to create Shared MetaData? (Select three)

A. DataStage table definition B. DB2 Connector C. Oracle Connector D. Dataset stage E. Sequential file stage

Correct Answer: A,B,D

Question 3

A job needs to split a single Data Set into three Data Sets based on conditions that are supplied at runtime. Which stage would allow you to parameterize the conditions for splitting the input data set?

A. Switch stage B. Split Vector stage C. Filter stage D. Transformer stage

Correct Answer: C

Question 4

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

A. The target stage variable is populated with spaces or zeros depending on the stage variable data type. B. NULL is written to the target stage variable. C. The input row is either dropped or rejected depending on whether the Transformer has a reject link. D. The job aborts.

Correct Answer: B

Question 5

Configuring the weighting column of an Aggregator stage affects which three options. (Choose three.)

A. Sum B. Maximum Value C. Sum of Weights D. Corrected Sum of Squares E. Percent Coefficient of Variation

Correct Answer: A,C,E

Question 6

What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

A. Define record ID constraints on the Records ID tab of the Complex Flat File stage. B. Use a Modify stage to convert the output array from the Complex Flat File to a subrecord. C. Manually break the file into multiple files by record type. D. Define record definitions on the Constraints tab of the Complex Flat File stage.

Correct Answer: A

Question 7

You found there were common functional requirements in the data mapping specification. The required functions are same but the record formats are different. Which action will allow you to effectively implement common logic?

A. Create parallel routines. B. Create parallel shared containers and define columns combining all data formats. C. Create separate jobs and choose appropriate job within a job sequence. D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary columns needed for the logic.

Correct Answer: D

Question 8

You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How can you find these jobs?

A. Sort the jobs by date in the Repository window. B. While selecting the top folder in the project, choose Find Dependencies. C. Use the Advanced Find feature contained in the Designer interface. D. Filter jobs in Director Client's Repository window.

Correct Answer: C

Question 9

Refer to the exhibit.

You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps-ef | grepds" and receive the following screen:
Which process is the section leader for node2?

A. 7216 B. 7220 C. 7221 D. 7219

Correct Answer: C

IBM InfoSphere DataStage v8.5 - 000-421 Exam Practice Test