CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS PAPER 2026 SOLVED
QUESTIONS AND FULL SOLUTION GRADED A+
◉ 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.
, ◉ True or False: Naming conventions are enforced in Caboodle.
Answer: True. Naming conventions are enforced in Caboodle.
◉ What is the relationship between SlicerDicer and Caboodle?
Answer: SlicerDicer is Epic's self service reporting tool in
Hyperspace that dynamically queries Caboodle data.
◉ What is the surrogate key for MedicationOrderFact?
Answer: MedicationOrderKey
◉ How are foreign keys documented in the Dictionary?
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.
◉ True or False: A maximum of one foreign key can exist between
two tables in Caboodle.
Answer: False. Multiple foreign keys can exist between two tables in
Caboodle.
◉ How can MedicationOrderFact join to PatientDim?
Answer: MedicationOrderFact.PatientKey = PatientDim.PatientKey
or MedicationOrderFact.PatientDurableKey =
PatientDim.PatientDurableKey
FUNDAMENTALS PAPER 2026 SOLVED
QUESTIONS AND FULL SOLUTION GRADED A+
◉ 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.
, ◉ True or False: Naming conventions are enforced in Caboodle.
Answer: True. Naming conventions are enforced in Caboodle.
◉ What is the relationship between SlicerDicer and Caboodle?
Answer: SlicerDicer is Epic's self service reporting tool in
Hyperspace that dynamically queries Caboodle data.
◉ What is the surrogate key for MedicationOrderFact?
Answer: MedicationOrderKey
◉ How are foreign keys documented in the Dictionary?
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.
◉ True or False: A maximum of one foreign key can exist between
two tables in Caboodle.
Answer: False. Multiple foreign keys can exist between two tables in
Caboodle.
◉ How can MedicationOrderFact join to PatientDim?
Answer: MedicationOrderFact.PatientKey = PatientDim.PatientKey
or MedicationOrderFact.PatientDurableKey =
PatientDim.PatientDurableKey
