The data going into the target Sequential Files stage is range-partitioned and sorted. Which
technique method would be the most efficient to create a globally sorted target sequential file?

In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File
stage with “Readers per Node” set to “2”. Input 2 (Dataset) comes from a dataset created with 3
partitions. In the Funnel stage, the funnel type is set to “Sequence”.

The parallel configuration file contains 4 nodes. How many instances of the Funnel stage run in
parallel?

Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled
with “Add checkpoints so sequence is restartable”. Job1 must execute every run even after a
failure. Which two properties must be selected to ensure that Job1 is run each time, even after a
failure? (Choose two.)

Which two actions are available when editing a message handler? (Choose two.)

What is the result of running the following command: dsjob -report DSProject ProcData

You would like to pass values into parameters that will be used in a variety of downstream activity
stages within a job sequence. What are two valid ways to do this? (Choose two.)

On the DataStage development server, you have been making enhancements to a copy of a
DataStage job running on the production server. You have been asked to document the changes
you have made to the job. What tool in DataStage Designer would you use?

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 a former developer of the project. How can you find these
jobs?

Your customer is using Source Code Control Integration for Information server and have tagged
artifacts for version 1. You must create a deployment package from the version 1. Before you
create the package you will have to ensure the project is up to date with version 1. What two
things must you do to update the meta-data repository with the artifacts tagged as version 1?
(Choose two.)

You want to find out which table definitions have been loaded into a job, and specifically which
stages of the job they has been loaded into? How will you determine this?