CDW 110v Caboodle Data Model Fundamentals 170 ACTUAL
EXAM TEST QUESTIONS & ANSWERS (A+ GRADED 100%
VERIFIED) 2025 LATEST!!
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.
OLIVIA GREENWAYS© 2025, ALL RIGHTS RESRVED 1
,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.
OLIVIA GREENWAYS© 2025, ALL RIGHTS RESRVED 2
, 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.
OLIVIA GREENWAYS© 2025, ALL RIGHTS RESRVED 3
EXAM TEST QUESTIONS & ANSWERS (A+ GRADED 100%
VERIFIED) 2025 LATEST!!
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.
OLIVIA GREENWAYS© 2025, ALL RIGHTS RESRVED 1
,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.
OLIVIA GREENWAYS© 2025, ALL RIGHTS RESRVED 2
, 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.
OLIVIA GREENWAYS© 2025, ALL RIGHTS RESRVED 3
