CDW 110v Caboodle Data Model
Fundamentals 170 Exam Questions and
Answers
True or False: A caboodle report may contain at most 1 conformed dimension? - ANS False. A
Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ANS A single table
and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - ANS 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? -
ANS Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ANS False. Caboodle and
Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - ANS Surrogate
key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ANS From Clarity, which gets its data from
Chronicles.
Pg. 1 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
,True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? -
ANS False. Caboodle developers can also SSIS packages to move data from Clarity to
Caboodle.
Caboodle is designed to... - ANS Store Epic data, store non-Epic data, make reporting easy,
interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ANS False
Name three documentation resources for Caboodle resources. - ANS 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? - ANS Because the console can be highly customized for your
organization.
What are the differences between a normalized and dimensional data model? - ANS 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. - ANS False, released
every four to six months.
Explain the role of the Caboodle report writer. - ANS Queries data that already exists in the
database.
Explain the role of the Caboodle administrator. - ANS Uses the Caboodle console to mange
and monitor the ETL process.
Pg. 2 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
, Explain the Caboodle developer role. - ANS Designs custom Data Model Components and
SSIS packages to bring additional data into the data warehouse.
True or False: Naming conventions are enforced in Caboodle. - ANS True. Naming
conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - ANS SlicerDicer is Epic's self
service reporting tool in Hyperspace that dynamically queries Caboodle data.
What is the surrogate key for MedicationOrderFact? - ANS MedicationOrderKey
How are foreign keys documented in the Dictionary? - ANS 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.
True or False: A maximum of one foreign key can exist between two tables in Caboodle. -
ANS False. Multiple foreign keys can exist between two tables in Caboodle.
How can MedicationOrderFact join to PatientDim? - ANS MedicationOrderFact.PatientKey =
PatientDim.PatientKey or MedicationOrderFact.PatientDurableKey =
PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - ANS Yes, example
MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - ANS Users and
Diagnosis Definitions
Pg. 3 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
Fundamentals 170 Exam Questions and
Answers
True or False: A caboodle report may contain at most 1 conformed dimension? - ANS False. A
Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ANS A single table
and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - ANS 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? -
ANS Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ANS False. Caboodle and
Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - ANS Surrogate
key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ANS From Clarity, which gets its data from
Chronicles.
Pg. 1 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
,True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? -
ANS False. Caboodle developers can also SSIS packages to move data from Clarity to
Caboodle.
Caboodle is designed to... - ANS Store Epic data, store non-Epic data, make reporting easy,
interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ANS False
Name three documentation resources for Caboodle resources. - ANS 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? - ANS Because the console can be highly customized for your
organization.
What are the differences between a normalized and dimensional data model? - ANS 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. - ANS False, released
every four to six months.
Explain the role of the Caboodle report writer. - ANS Queries data that already exists in the
database.
Explain the role of the Caboodle administrator. - ANS Uses the Caboodle console to mange
and monitor the ETL process.
Pg. 2 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
, Explain the Caboodle developer role. - ANS Designs custom Data Model Components and
SSIS packages to bring additional data into the data warehouse.
True or False: Naming conventions are enforced in Caboodle. - ANS True. Naming
conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - ANS SlicerDicer is Epic's self
service reporting tool in Hyperspace that dynamically queries Caboodle data.
What is the surrogate key for MedicationOrderFact? - ANS MedicationOrderKey
How are foreign keys documented in the Dictionary? - ANS 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.
True or False: A maximum of one foreign key can exist between two tables in Caboodle. -
ANS False. Multiple foreign keys can exist between two tables in Caboodle.
How can MedicationOrderFact join to PatientDim? - ANS MedicationOrderFact.PatientKey =
PatientDim.PatientKey or MedicationOrderFact.PatientDurableKey =
PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - ANS Yes, example
MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - ANS Users and
Diagnosis Definitions
Pg. 3 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
