IBM 000-421 Actual Free Exam Questions & Community Discussion

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

Which three data types can the ODBC Enterprise stage handle? (Choose three.)

A copy of a production job was moved into a development project and modified to improve performance. You must prepare a report for a code review that documents the changes to the job.
How would you gather the information for this report? (Select two)

There is a requirement to transfer a large file using an FTP Enterprise stage. How can you minimize processing time when a transfer failure occurs?

You have a dataset hash-partitioned and sorted on CustID. You need to create a Sequential File sorted on CustID from this dataset. Which technique is the most appropriate?

How are Shared Table definitions created from the DataStage Client?

Which three statements are true about File Sets? (Choose three.)

In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages.
You have been asked to reduce the number of sorts to improve the performance of the job.

Which two ways might be used to accomplish this without changing how the job functions? (Select two)

You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.
What are two requirements on the input link data for the Change Capture stage? (Select two)

Which three environment variables are valid job score environment variables? (Select three)

What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)

You have a DataStage job on SMP environment. It contains an input sequential file, a Modify stage, followed by a Transformer stage, and an output Sequential File stage. The job is run with three nodes. The engine uses all default settings. How many processes will this job create?