Online Access Free C-BODI-20 Practice Test

Where do you specify the error file to capture flat file format errors?

• A.File Format Editor
• B.Properties of the Data Flow
• C.Trace Options of the Job
• D.Server Manager Tool

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 "In" option and "Action On Failure I Send to Both", select "For pass, substitute with".
• B.Select "In" option and "Action On Failure I Send to Fail", select "For pass, substitute with".
• C.Select "Exists in table" and "Action On Failure I Send to Both", select "For Pass, substitute with".
• D.Select "Exists in table" and "Action On Failure I Send to Fail", select "For Pass, substitute with".

You need to merge two tables from heterogeneous data sources and apply multiple join conditions. The tables contain very large data volumes. What is the recommended method to maximize performance and reduce system resources?

• A.Use the Merge transform to merge the data into a single Table before applying the join conditions
• B.Use Multiple Flat Files to stage the tables, then join the flat files using a Query transform.
• C.Use the Data_Transfer transform to stage the tables in the same database before applying the join conditions
• D.Use the Query transform to join the two tables by applying the join conditions.

Which two components are required to execute a batch job? (Choose two)

• A.Central Management Console
• B.Repository
• C.Batch Server
• D.Job Server
• E.Designer

You are executing a Job in Recovery mode and the Job fails having partially loaded the Target Table. You rerun the Job by selecting "Recover from last failed execution"

• A.The objects completed prior to the failed Data Flow are skipped and the failed Data Flow continues from the point of failure
• B.The objects completed prior to and including the failed Data Flow are re-run in Auto-correct mode
• C.The transaction is rolled back and the Job re-executes from the beginning
• D.The objects completed prior to the failed Data Flow are skipped and the failed Data Flow is rerun from the beginning