Free IBM 000-421 Practice Test & Real Exam Questions

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 script invokes an update job called "UpdateKeys" via a command line invocation of the dsjob command. The service is to wait for the completion and status of this job before continuing with the rest its tasks. Which three commands would invoke the "UpdateKeys" job in the MigrationProject and wait for its completion status? (Select three)

A client needs to process a flat file where a set of values in the import data columns should be treated as Null. What is the best way to handle multiple Null values using a Sequential File stage?

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 meta-data will help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

You are setting up user roles on Information Server Web console. Which two roles are required to allow a user to edit DataStage jobs? (Select two)

What conditions are necessary for a master record and an update record to merge?

Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)

Which statement is true about buffering?

What would help debug the run-time environment?