QUESTION: 1
You are developing a data warehouse as part of a large development team (ten plus
developers) Way should you recommend a multi-user configuration? (Choose two)

A. Attach documentation based on object history
B. Ensure only one developer is working on a specific set of objects
C. Store table column and relationship profile data including history
D. Track the version history history of objects(audit trrail)

Answer(s): B, D

QUESTION: 2
In which three objects can you include a try/catch block? (Choose three)

A. Data Flow
B. Job
C. Script
D. Work Flow

Answer(s): B, C, D

QUESTION: 3
How do you create multiple instances of the same Data Flow?

A. Right-click+Replicate on the Data Flow in the Local Object Library
B. Right-click_Copy/Paste Data Flow from the Job wrorkspace
C. Right-click_Copy/Paste Data Flow in the Local Object Library
D. Right-click+Replicate Data Flow from the Job workspace

Answer(s): A

QUESTION: 4
Your sales order fact table load contains a reference to a customer _id not found in the
customer dimension table. How can you replace the customer_id with a default value and
preserve the original record using the Validation transform?

A. Select "Exists in table" and "Action On Failure I Send to Both", select "For Pass, substitute
with".
B. Select "Exists in table" and "Action On Failure I Send to Fail", select "For Pass, substitute
with".
C. Select "In" option and "Action On Failure I Send to Both", select "For pass, substitute with".
D. Select "In" option and "Action On Failure I Send to Fail", select "For pass, substitute with".

Answer(s): A

QUESTION: 5