Online Access Free C-BODI-20 Exam Questions

You are unfamiliar with the data in the customer dimension and sales fact tables. The tables are related by the customer_id field. You execute a relationship profile on the tables. Which two insights will you gain from reviewing the relationship results? (Choose two)

• A.Customers records in the customer table that have matching records in the sales table
• B.Foreign key constraints that ensure customers in the dales table also have matching records in the customer table
• C.Foreign key constraints that ensure customers in the customers table also have matching records in the sales table
• D.Customers records in the sales table that have matching records in the customer table

What are the three possible row operation codes for input to the History_ Preserving transform?
(Choose three)

• A.Normal
• B.Delete
• C.Update
• D.Discard
• E.Insert

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.Track the version history history of objects(audit trrail)
• D.Store table column and relationship profile data including history

Which three elements can be contained in the output schema of a query? (Choose three)

• A.Group By
• B.Filters
• C.Order By
• D.Functions
• E.Columns
• F.Nested Schemas

Which two syntactical items can you check by selecting "Validate All"? (Choose two)

• A.Job structure
• B.Contents of SQL function calls
• C.Existence of variables
• D.Contents of SQL transform