Important Note, Please Read Carefully
Other TopCerts products
A) Offline Testing engine
Use the offline Testing engine product topractice the questions in an exam environment.
Build a foundation of knowledge which will be useful also after passing the exam.
Latest Version
We are constantly reviewing our products. New material is added and old material is
revised. Free updates are available for 90 days after the purchase. You should check your
member zone at TopCerts and update 3-4 days before the scheduled exam date.
Here is the procedure to get the latest version:
1.Go towww.TopCerts.com
2.Click on Log in
3.The latest versions of all purchased products are downloadable from here. Just click the
links.
For most updates,it is enough just to print the new questions at the end of the new
version, not the whole document.
Feedback
If you spot a possible improvement then please let us know. We always interested in
improving product quality.
Feedback should be send to feedback@TopCerts.com. You should include the following:
Exam number, version, page number, question number, and your login Email.
Our experts will answer your mail promptly.
Copyright
Each iPAD file is a green exe file. if we find out that a particular iPAD Viewer file is
being distributed by you, TopCerts reserves the right to take legal action against you
according to the International Copyright Laws.
Explanations
This product does not include explanations at the moment. If you are interested in
providing explanations for this exam, please contact feedback@TopCerts.com.

Leading the way in IT testing and certification tools, www.TopCerts.com

-2-

www.TopCerts.com Q: 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: B, D
www.TopCerts.com Q: 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: B, C, D
www.TopCerts.com Q: 3 How do you create multiple instances of the same Data
Flow?

Leading the way in IT testing and certification tools, www.TopCerts.com

-3-

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: A
www.TopCerts.com Q: 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?

Answer: C
www.TopCerts.com Q: 10 You have a source table that contains fifty columns. You
need to place business rules on thirty of the columns to check the format of the
source data and filter the valid and invalid records. You also want to analyze the
column values that fail. What is the recommended method you should use?

A. Use a Case transform to create two conditions that filter the invalid records

Leading the way in IT testing and certification tools, www.TopCerts.com

-6-

B. Use a Map_Operation transform to map valid and invalid data rules
C. Use a Validation transform and enable validation rules on the required columns
D. Use two Query transforms with different WHERE clauses to filter the invalid records

Answer: C

Leading the way in IT testing and certification tools, www.TopCerts.com