CDW110 EXAMS 3 TESTED QUESTIONS 2026
FULL SOLUTION GUIDE
◉ 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.
FULL SOLUTION GUIDE
◉ 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.
