IBM Websphere Datastage V.8.0 - C2090-418 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A DataStage job uses an Inner Join to combine data from two source parallel data sets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)

A. Explicitly specify hash partitioning and sorting on each input to the Join stage. B. Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key. C. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY. D. Unset the Preserve Partitioning flag on the output of each parallel data set.

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

Multiple "resource disk" entries for each node allows for which two events? (Choose two.)

A. Additional processes to handle all I/O. B. File Sets and Data Sets to be written/read in multiple locations. C. Buffers to be written/read in multiple disk locations. D. Prevents jobs from aborting if a single resource disk location fills.

Discussion 0

Correct Answer: B,D Vote an answer

Question 3

Which three statements describe a DataStage installation in a clustered environment? (Choose three.)

A. For clustered implementations, appropriate node pools are useful to reduce data shipping. B. Compiled job and all shared components must be available across all servers. C. The conductor node will create the job score and consolidate messages to the DataStage log. D. All machines within the cluster must have connectivity to the metadata repository. E. DataStage must be installed on the same kind of operating system as the metadata repository.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 4

Click the Exhibit button.
In the exhibit, data is being read from a Sequential File stage (Read_Selling_Group_Mapping) and written to a target Data Set stage (Write_Selling_Group_Mapping_Copy). All columns are being mapped source to target in the Copy stage. After the job is executed using a 2-node configuration file, you notice that the Data Set has only one partition. What are two actions that can be done to this job to ensure Data Set has two partitions? (Choose two.)

A. Disable Runtime Column Propagation (RCP) and set "Force" option in the Copy stage to "TRUE". B. Disable Runtime Column Propagation (RCP) and set "Force" option in the Data Set stage to "TRUE". C. Enable Runtime Column Propagation (RCP) and set "Force" option in the Copy stage to "TRUE". D. Enable Runtime Column Propagation (RCP) and set "Force" option in the Copy stage to "FALSE".

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

You have been asked to identify all of the job objects that use a particular Table Definition. This task must be performed to evaluate the impact of this layout change for your DataStage application. To accomplish this task, which two steps must have been completed by the job developers to allow you to locate all of the jobs associated with the table definition? (Choose two.)

A. The Cross Reference object must be created. B. The job stage column tab properties must be entered using 'Load' button within the Table Definition. C. The Table Definition object must be created. D. The job stage cross reference properties must be entered using the Table Definition name.

Discussion 0

Correct Answer: B,C Vote an answer

Question 6

When defining a message handler, which three actions can be specified for a message?
(Choose three.)

A. Promote to "Warning". B. Suppress from log. C. Demote to "Informational". D. Promote to "Fatal". E. Demote to "Warning".

Discussion 0

Correct Answer: A,B,C Vote an answer