Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a
single existing table on a remote database. You are using Run-Time Column Propagation (RCP)
on all of the links.
Which two job design configuration actions would you consider to effectively use RCP? (Select
two)

How are Host Systems added to the Shared Metadata repository? (Select two)

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

What are the three features of Information Server that allow you to deploy DataStage objects?
(Select 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)

In your DB2 database you have column names that use characters # and $. Which two steps
should be completed to allow DataStage to convert these characters into internal format and back
as necessary? (Select two)

You have a dataset that is range-partitioned and sorted. Which technique is most efficient to
create globally sorted data file?

A scenario requires selecting only the most recent transactions for each of 2 million unique
customers, from a 20 million row DB2 source table containing order history. Which parallel job
design would satisfy this functional requirement?

Which two statements are true for named node pools? (Select two)

Which three statements are true about stage variables? (Select three)