1|Page
CDW110 EXAM/CDW110 EXAM PREPARATION/CDW110
PRACTICE EXAM ACTUAL EXAM QUESTIONS AND
CORRECT DETAILED ANSWERS|AGRADE A+
True or False: A caboodle report may contain at most 1 conformed
dimension? ......ANSWER......False. A Caboodle report can contain
multiple conformed dimensions.
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.
,2|Page
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
, 3|Page
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
CDW110 EXAM/CDW110 EXAM PREPARATION/CDW110
PRACTICE EXAM ACTUAL EXAM QUESTIONS AND
CORRECT DETAILED ANSWERS|AGRADE A+
True or False: A caboodle report may contain at most 1 conformed
dimension? ......ANSWER......False. A Caboodle report can contain
multiple conformed dimensions.
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.
,2|Page
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
, 3|Page
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
