CDW110V CABOODLE DATA MODEL
FUNDAMENTALS FINAL PAPER 2026 COMPLETE
QUESTIONS AND ANSWERS
◉ 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?
, Answer: Yes, example MedicationOrderFact can join to
EncounterFact.
◉ Which of the following would you expect to be stored in a
dimension table?
Answer: Users and Diagnosis Definitions
◉ Which of the following are possible to do in Caboodle?
Answer: Joining a fact table to another fact table, Fact table to
dimension table, dimension table to dimension table, 2 different EAV
dim table to an attribute dim table
◉ True or False: Any change to Patient data in Clarity will generate a
new row in PatientDim after the next extract.
Answer: False, only changes in type 2 data would result in a new row
being generated.
◉ True of false: The _Current view tables in the FullAccess schema
contains a subset of the rows contained in their corresponding type
2 tables.
Answer: True. _Current view tables in the Fullaccess schema contain
a subset of the rows contained in their corresponding type 2 tables.
◉ What is a durable key?
FUNDAMENTALS FINAL PAPER 2026 COMPLETE
QUESTIONS AND ANSWERS
◉ 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?
, Answer: Yes, example MedicationOrderFact can join to
EncounterFact.
◉ Which of the following would you expect to be stored in a
dimension table?
Answer: Users and Diagnosis Definitions
◉ Which of the following are possible to do in Caboodle?
Answer: Joining a fact table to another fact table, Fact table to
dimension table, dimension table to dimension table, 2 different EAV
dim table to an attribute dim table
◉ True or False: Any change to Patient data in Clarity will generate a
new row in PatientDim after the next extract.
Answer: False, only changes in type 2 data would result in a new row
being generated.
◉ True of false: The _Current view tables in the FullAccess schema
contains a subset of the rows contained in their corresponding type
2 tables.
Answer: True. _Current view tables in the Fullaccess schema contain
a subset of the rows contained in their corresponding type 2 tables.
◉ What is a durable key?
