Free 000-421 Questions for IBM 000-421 Exam

Question #1

How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?

A. RCP is by default available for all DataStage Projects.

B. Use the DataStage Administrator to enable RCP for the project.

C. Use the Info Server web console to enable RCP

D. Set the APT_ENABLE_RCP environment variable to TRUE.

E. Use RCP definition wizard to initialize RCP for project use.

Discussion 0

Correct Answer: B Vote an answer

Question #2

How is DataStage Table Metadata shared among DataStage projects?

A. Use the "Shared Table Creation Wizard" to create a copy of the table in the shared repository.

B. DataStage Tables cannot be shared between projects.

C. Import another copy of the table metadata into the project where it is required.

D. Use the Import/Export Manager to move the DataStage Table Definition to the projects where it is needed.

E. Export DataStage Table Definitions from one project and importing them into another project.

Discussion 0

Correct Answer: A Vote an answer

Question #3

External data conversions fall in two major types - automatic and manual. What are the three automatic conversions? (Select three)

A. SAS data

B. Sequential File stage

C. Modify operator

D. Flat Text files

E. Relational data

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #4

Which of the following describes a type two update in a Slowly Changing Dimensions (SCD) stage?

A. An update the retains the existing column value in an historical row and creates a new row with the new value.

B. An update that replaces the existing column value if a specified condition is satisfied.

C. An update that overwrites the existing column value.

D. An update that retains the existing column value in a list and adds the new value to the list.

Discussion 0

Correct Answer: D Vote an answer

Question #5

You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2 Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise Stage.
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)

A. Dependent upon

B. Include Read only objects

C. Where used

D. Type

Discussion 0

Correct Answer: C,D Vote an answer

Question #6

A star schema data warehouse consists of four dimension tables and one fact table. How many Slowly Changing Dimensions (SCD) stages will you need in your jobs to update the star schema tables?

A. two

B. three

C. five

D. four

Discussion 0

Correct Answer: D Vote an answer

Question #7

Which two statements are true about the usage of scratch disk? (Choose two.)

A. The parallel framework uses the disk space specified in the scratch disk setting to buffer virtual data set records.

B. The Sort stage always uses the scratch disk.

C. If "buffer" scratch disk pool is defined, the framework uses this disk pool and the default disk pool.

D. You can define multiple scratch disk spaces to distribute disk I/O.

Discussion 0

Correct Answer: A,D Vote an answer

Question #8

Which two job design techniques can be used to provide unique names to sequential output files that are used in multi-instance jobs? (Select two)

A. Create the file name(s) from values contained in a value file.

B. Use the file name(s) from values contained in the data stream.

C. Use parameters to identify file names.

D. Prepend/append the Invocation ID to the file name.

Discussion 0

Correct Answer: C,D Vote an answer

Question #9

You have been given operational requirements to introduce data recovery to one of your parallel job designs. Additionally, you have been told that you are to use flat files as your intermediate data structure. Which two tasks will accomplish these objectives? (Choose two.)

A. Use the Sequential stage to export and import data between jobs.

B. Break up the design by splitting it into at least two parallel jobs.

C. Enable checkpoint restartability in each of your parallel stages.

D. Use the Hash File stage to write and read data between parallel jobs.

Discussion 0

Correct Answer: A,B Vote an answer

Question #10

What two stages are required to place Header and Detail records, which have different formats, into a single format? (Choose two.)

A. Combine Stage

B. Column Export Stage

C. Funnel Stage

D. Column Import Stage

Discussion 0

Correct Answer: B,C Vote an answer

Question #11

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

A. Containers allow you to implement recurring logic.

B. Containers are a group of stages and links.

C. Containers allow multiple users to access a single job.

D. Containers allow you to provide pre-configured job design logic.

E. Containers are used to execute jobs.

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Question #12

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

A. Sum

B. Sum of Weights

C. Maximum Value

D. Corrected Sum of Squares

E. Percent Coefficient of Variation

Discussion 0

Correct Answer: A,B,E Vote an answer

Free 000-421 Questions for IBM InfoSphere DataStage v8.5 000-421 Exam as PDF & Practice Test Engine

Download Free IBM 000-421 Demo