CDW 110v Caboodle Data Model
Fundamentals Exam 2026 Questions and
Answers
True or False: A caboodle report may contain at most 1 conformed dimension? -
Correct answer-False. A Caboodle report can contain multiple conformed
dimensions.
Which of the following can be populated by more than one package? - Correct
answer-A single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - Correct 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? - Correct answer-Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - Correct
answer-False. Caboodle and Clarity cannot be used interchangeably.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
,Which of the following types of columns would you find in a type 1 table? -
Correct answer-Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - Correct 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? - Correct answer-False. Caboodle developers can also SSIS packages to
move data from Clarity to Caboodle.
Caboodle is designed to... - Correct answer-Store Epic data, store non-Epic data,
make reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - Correct answer-False
Name three documentation resources for Caboodle resources. - Correct 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? - Correct answer-Because the console can
be highly customized for your organization.
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
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
, 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. - Correct
answer-False, released every four to six months.
Explain the role of the Caboodle report writer. - Correct answer-Queries data that
already exists in the database.
Explain the role of the Caboodle administrator. - Correct answer-Uses the
Caboodle console to mange and monitor the ETL process.
Explain the Caboodle developer role. - Correct answer-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. - Correct answer-
True. Naming conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - Correct answer-
SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically
queries Caboodle data.
What is the surrogate key for MedicationOrderFact? - Correct answer-
MedicationOrderKey
©COPYRIGHT 2025, ALL RIGHTS RESERVED 3
Fundamentals Exam 2026 Questions and
Answers
True or False: A caboodle report may contain at most 1 conformed dimension? -
Correct answer-False. A Caboodle report can contain multiple conformed
dimensions.
Which of the following can be populated by more than one package? - Correct
answer-A single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - Correct 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? - Correct answer-Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - Correct
answer-False. Caboodle and Clarity cannot be used interchangeably.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
,Which of the following types of columns would you find in a type 1 table? -
Correct answer-Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - Correct 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? - Correct answer-False. Caboodle developers can also SSIS packages to
move data from Clarity to Caboodle.
Caboodle is designed to... - Correct answer-Store Epic data, store non-Epic data,
make reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - Correct answer-False
Name three documentation resources for Caboodle resources. - Correct 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? - Correct answer-Because the console can
be highly customized for your organization.
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
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
, 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. - Correct
answer-False, released every four to six months.
Explain the role of the Caboodle report writer. - Correct answer-Queries data that
already exists in the database.
Explain the role of the Caboodle administrator. - Correct answer-Uses the
Caboodle console to mange and monitor the ETL process.
Explain the Caboodle developer role. - Correct answer-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. - Correct answer-
True. Naming conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - Correct answer-
SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically
queries Caboodle data.
What is the surrogate key for MedicationOrderFact? - Correct answer-
MedicationOrderKey
©COPYRIGHT 2025, ALL RIGHTS RESERVED 3
