CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM QUESTIONS AND
VERIFIED ANSWERS UPDATED
Question 1
What is the difference between a MappingFact table and a Bridge table?
Correct Answer
Both are used to map many-to-many relationships, however, Bridge table always
link to a Dimension table while MappingFact tables link to Fact tables.
Question 2
What are the differences between a normalized and dimensional data model?
Correct Answer
In a normalized data model, the focus is on not repeating data. Ina dimensional
data model, the focus us on ease of reporting, and uses the star schema which
focuses on a central fact table.
Question 3
Define IdType
Correct Answer
Question 4
DBO (Reporting Tables reside in this Schema)
Correct Answer
DBO are a way to organize tables. Import tables used by developers to store data.
Page 1 of 54
,Question 5
How can you track Caboodle upgrade progress?
Correct Answer
the Caboodle Changelog Assistant spreadsheet
Question 6
Define Attribute
Correct Answer
Question 7
What is "X" table naming convention?
Correct Answer
custom tables (e.g. CustomFactX)
Question 8
How are business keys in Caboodle stored?
Correct Answer
business keys in Caboodle are stored in two columns
1. IdType
2. Id
Question 9
How are foreign keys documented in the Dictionary?
Correct Answer
Table that link to or from a given table are listed under properties, and hyperlinks to
the destination table are provided next to foreign key column descriptions.
Page 2 of 54
,Question 10
Explain the Caboodle developer role.
Correct Answer
Designs custom Data Model Components and SSIS packages to bring additional
data into the data warehouse.
Question 11
Explain how data flows into Caboodle.
Correct Answer
Question 12
What is Chronicles?
Correct Answer
Chronicles is Epic's operational database. Written in the M programming language,
Chronicles is optimized to support end users in their day-to-day work. Data entered
here is extracted, on a nightly basis, to Clarity.
Question 13
Define "IdType"
Correct Answer
the IdType column contains a string value that specifies the type of entity loaded
Question 17
True or False: Every row in DepartmentDim represents a department.
Correct Answer
False. Rows in DeptartmentDim represent many different data types, ex: bed, room,
room group, etc.
Page 3 of 54
, Question 18
How do you look up the data lineage of a column?
Question 19
Define Dimension Table
Correct Answer
Question 20
Define Dictionary
Correct Answer
Question 21
How do you create reports using bridges (dbo and FullAccess)
Correct Answer
Question 22
Define "Durable key"
Correct Answer
Every type 2 DMC has a column named DurableKey. This column contains the same
value for all the rows that belong to a specific entity. For example, in PatientDim, all
the rows corresponding to a specific patient will have the same durable key. (each
row will have a unique surrogate key)
Question 23
What is the "Caboodle Developer's Guide"?
Correct Answer
Step-by-step documentation on how to create custom DMC's and packages
Page 4 of 54
FUNDAMENTALS EXAM QUESTIONS AND
VERIFIED ANSWERS UPDATED
Question 1
What is the difference between a MappingFact table and a Bridge table?
Correct Answer
Both are used to map many-to-many relationships, however, Bridge table always
link to a Dimension table while MappingFact tables link to Fact tables.
Question 2
What are the differences between a normalized and dimensional data model?
Correct Answer
In a normalized data model, the focus is on not repeating data. Ina dimensional
data model, the focus us on ease of reporting, and uses the star schema which
focuses on a central fact table.
Question 3
Define IdType
Correct Answer
Question 4
DBO (Reporting Tables reside in this Schema)
Correct Answer
DBO are a way to organize tables. Import tables used by developers to store data.
Page 1 of 54
,Question 5
How can you track Caboodle upgrade progress?
Correct Answer
the Caboodle Changelog Assistant spreadsheet
Question 6
Define Attribute
Correct Answer
Question 7
What is "X" table naming convention?
Correct Answer
custom tables (e.g. CustomFactX)
Question 8
How are business keys in Caboodle stored?
Correct Answer
business keys in Caboodle are stored in two columns
1. IdType
2. Id
Question 9
How are foreign keys documented in the Dictionary?
Correct Answer
Table that link to or from a given table are listed under properties, and hyperlinks to
the destination table are provided next to foreign key column descriptions.
Page 2 of 54
,Question 10
Explain the Caboodle developer role.
Correct Answer
Designs custom Data Model Components and SSIS packages to bring additional
data into the data warehouse.
Question 11
Explain how data flows into Caboodle.
Correct Answer
Question 12
What is Chronicles?
Correct Answer
Chronicles is Epic's operational database. Written in the M programming language,
Chronicles is optimized to support end users in their day-to-day work. Data entered
here is extracted, on a nightly basis, to Clarity.
Question 13
Define "IdType"
Correct Answer
the IdType column contains a string value that specifies the type of entity loaded
Question 17
True or False: Every row in DepartmentDim represents a department.
Correct Answer
False. Rows in DeptartmentDim represent many different data types, ex: bed, room,
room group, etc.
Page 3 of 54
, Question 18
How do you look up the data lineage of a column?
Question 19
Define Dimension Table
Correct Answer
Question 20
Define Dictionary
Correct Answer
Question 21
How do you create reports using bridges (dbo and FullAccess)
Correct Answer
Question 22
Define "Durable key"
Correct Answer
Every type 2 DMC has a column named DurableKey. This column contains the same
value for all the rows that belong to a specific entity. For example, in PatientDim, all
the rows corresponding to a specific patient will have the same durable key. (each
row will have a unique surrogate key)
Question 23
What is the "Caboodle Developer's Guide"?
Correct Answer
Step-by-step documentation on how to create custom DMC's and packages
Page 4 of 54
