CDW110V CABOODLE DATA MODEL FUNDAMENTALS EXAM WITH
CORRECT ACTUAL QUESTIONS AND CORRECTLY WELL DEFINED ANSWERS
LATEST ALREADY GRADED A+ 2025 – 2026 FOR EPIC CERTIFICATION
PREPARATION
Define "Normalized data model" - ANSWER-Normalized databases avoid redundancies in the
data to make ETL safe and simple
Define "Dimensional data model" - ANSWER-1. The data is more accessible
2. Efficiency
3. Fewer tables and simpler joins
Define "Conformed dimension" - ANSWER-There are many fact DMC's in Caboodle. Rather
than define a complete set of dimensions for each, it's wise to reuse them wherever possible.
For example, most fact DMC's require a dimension describing patients, and they all reference
the same table (PatientDim) to do so. Dimensions that provide context to multiple facts in this
way are said to be conformed dimensions.
Define "Profile dimension" - ANSWER-A "Profile Dimension" holds dimensional data that is
specific to a single fact DMC.
Define " Surrogate key" - ANSWER-represents an entity in a moment in time.
Define "Durable key" - 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)
True or False: A caboodle report may contain at most 1 conformed dimension? - ANSWER-
False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ANSWER-A single table
and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - ANSWER-When the foreign key
in the source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers? -
ANSWER-Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ANSWER-False. Caboodle
and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - ANSWER-Surrogate
key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ANSWER-From Clarity, which gets its data
from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? -
ANSWER-False. Caboodle developers can also SSIS packages to move data from Clarity to
Caboodle.
, Caboodle is designed to... - ANSWER-Store Epic data, store non-Epic data, make reporting easy,
interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ANSWER-False
Name three documentation resources for Caboodle resources. - ANSWER-Caboodle dictionary,
Reporting with Caboodle document, Caboodle ER diagram.
When writing reports, why is it better to use your organization's Caboodle console rather than
the console used in training? - ANSWER-Because the console can be highly customized for your
organization.
What are the differences between a normalized and dimensional data model? - 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.
True or False: A new version of Caboodle is released every month. - ANSWER-False, released
every four to six months.
Explain the role of the Caboodle report writer. - ANSWER-Queries data that already exists in
the database.
Explain the role of the Caboodle administrator. - ANSWER-Uses the Caboodle console to mange
and monitor the ETL process.
Explain the Caboodle developer role. - ANSWER-Designs custom Data Model Components and
SSIS packages to bring additional data into the data warehouse.
CORRECT ACTUAL QUESTIONS AND CORRECTLY WELL DEFINED ANSWERS
LATEST ALREADY GRADED A+ 2025 – 2026 FOR EPIC CERTIFICATION
PREPARATION
Define "Normalized data model" - ANSWER-Normalized databases avoid redundancies in the
data to make ETL safe and simple
Define "Dimensional data model" - ANSWER-1. The data is more accessible
2. Efficiency
3. Fewer tables and simpler joins
Define "Conformed dimension" - ANSWER-There are many fact DMC's in Caboodle. Rather
than define a complete set of dimensions for each, it's wise to reuse them wherever possible.
For example, most fact DMC's require a dimension describing patients, and they all reference
the same table (PatientDim) to do so. Dimensions that provide context to multiple facts in this
way are said to be conformed dimensions.
Define "Profile dimension" - ANSWER-A "Profile Dimension" holds dimensional data that is
specific to a single fact DMC.
Define " Surrogate key" - ANSWER-represents an entity in a moment in time.
Define "Durable key" - 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)
True or False: A caboodle report may contain at most 1 conformed dimension? - ANSWER-
False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ANSWER-A single table
and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - ANSWER-When the foreign key
in the source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers? -
ANSWER-Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ANSWER-False. Caboodle
and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - ANSWER-Surrogate
key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ANSWER-From Clarity, which gets its data
from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? -
ANSWER-False. Caboodle developers can also SSIS packages to move data from Clarity to
Caboodle.
, Caboodle is designed to... - ANSWER-Store Epic data, store non-Epic data, make reporting easy,
interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ANSWER-False
Name three documentation resources for Caboodle resources. - ANSWER-Caboodle dictionary,
Reporting with Caboodle document, Caboodle ER diagram.
When writing reports, why is it better to use your organization's Caboodle console rather than
the console used in training? - ANSWER-Because the console can be highly customized for your
organization.
What are the differences between a normalized and dimensional data model? - 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.
True or False: A new version of Caboodle is released every month. - ANSWER-False, released
every four to six months.
Explain the role of the Caboodle report writer. - ANSWER-Queries data that already exists in
the database.
Explain the role of the Caboodle administrator. - ANSWER-Uses the Caboodle console to mange
and monitor the ETL process.
Explain the Caboodle developer role. - ANSWER-Designs custom Data Model Components and
SSIS packages to bring additional data into the data warehouse.
