Online Access Free C-BODI-20 Exam Questions

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".

Which two data integrator objects/operations support load balancing in a server Group based architecture? (Choose two.)

• A.Lookup_ext
• B.While loop
• C.Script
• D.Job

You are developing a data warehouse as part of a large development team (ten plus developers). Why should you recommednd a multi-user configuration? (Choose two)

• A.Notify development teams when changes occur automatically
• B.Enable developers to evert to previous versions of objects
• C.Assign object rights by development group
• D.Generate data lineage and impact analysis for the development project

Which two items are included on the Operational Dashboard? (Choose two)

• A.Job Execution Duration
• B.Job Execution Statistics
• C.Job Schedules
• D.Job Server Resource Utilization

You load over 10,000.000 records from the "customer" source table into a staging are a. You need to remove the duplicate customer during the loading of the source table. You do not nee tot record or audit the duplicates. Which two do-duplicating techniques will ensure that best performance? (Choose two.)

• A.Use the lookup_ext function. With the Pre_load_cache" option selected to test each row for duplicates.
• B.Use a Query transform to order the incoming data set an use the previous_row-value in the where clause to filter any duplicate row.
• C.Use the Query transform to order the incoming data set. Then a table_comparison transform with "input contains duplicates" and the "sorted input" options selected.
• D.Use tha table_ comparison transform with the "input contains duplicates" and "cached comparison table" selected.