CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM SCRIPT 2026 FULL
SOLUTION QUESTIONS AND ANSWERS
BUNDLED EXAMS 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
●● In Caboodle, can Fact tables be joined to other fact tables?.
FUNDAMENTALS EXAM SCRIPT 2026 FULL
SOLUTION QUESTIONS AND ANSWERS
BUNDLED EXAMS 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
●● In Caboodle, can Fact tables be joined to other fact tables?.
