CDW110 FINAL EXAM PAPER 2026 200
SOLVED QUESTIONS WITH DETAILED
CORRECT ANSWERS
⩥ 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.
SOLVED QUESTIONS WITH DETAILED
CORRECT ANSWERS
⩥ 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.
