Online Access Free C_BODI_20 Exam Questions

Which two engines process jobs on the Application server? (Choose two)

• A.Access Server
• B.Designer
• C.Batch Server
• D.Web Administrator
• E.Job Server

Which three expressions convert a null value to 0? (Choose three)

• A.Nvl (field,0)
• B.If then else (field is NULL,0,field)
• C.Case (field is NULL, 0, field)
• D.Decode (field is NULL, 0, field)

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

Which two changes to your Source Table requires you to re-import the metadata? (Choose two)

• A.Index changes
• B.Truncated table data
• C.Table structure changes
• D.New records added

Which two tasks must you perform to ensure the businessObject universe Bolder transfers the correct metadata lineage information? (Choose two)

• A.Calculate column dependencies
• B.Calculate column mappings
• C.Calculate table mappings
• D.Calculate usage dependencies