CDW 110V EXAM REVIEW SHEET COMPLETE QUESTIONS ANSWERS GRADED A PLUS
CDW110V EXAM 2026/2027 TEST BANK EXAM
Review WITH FULL Solution AND Verified
Questions and Answers Verified Solutions Latest
Update
Question:
Which of the following can be populated by more than one package?
Answer:
A single table and a single row in a table.
Question:
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.
Question:
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers?
Answer:
Dictionary and the Dictionary editor.
Question:
True or False: Caboodle and Clarity can be used interchangeably?
Answer:
False. Caboodle and Clarity cannot be used interchangeably.
Question:
,Which of the following types of columns would you find in a type 1 table?
Answer:
Surrogate key, foreign key, and a combo key.
Question:
Where does Epic data in Caboodle come from?
Answer:
From Clarity, which gets its data from Chronicles.
Question:
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.
Question:
Caboodle is designed to.
Answer:
Store Epic data, store non-Epic data, make reporting easy, interoperate with SlicerDicer.
Question:
Caboodle is considered a normalized database.
Answer:
False
Question:
Name three documentation resources for Caboodle resources.
,Answer:
Caboodle dictionary, Reporting with Caboodle document, Caboodle ER diagram.
Question:
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.
Question:
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.
Question:
True or False: A new version of Caboodle is released every month.
Answer:
False, released every four to six months.
Question:
Explain the role of the Caboodle report writer.
Answer:
Queries data that already exists in the database.
Question:
Explain the role of the Caboodle administrator.
, Answer:
Uses the Caboodle console to mange and monitor the ETL process.
Question:
Explain the Caboodle developer role.
Answer:
Designs custom Data Model Components and SSIS packages to bring additional data into the data
warehouse.
Question:
True or False: Naming conventions are enforced in Caboodle.
Answer:
True. Naming conventions are enforced in Caboodle.
Question:
What is the relationship between SlicerDicer and Caboodle?
Answer:
SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically queries Caboodle
data.
Question:
What is the surrogate key for MedicationOrderFact?
Answer:
MedicationOrderKey
Question:
How are foreign keys documented in the Dictionary?
CDW110V EXAM 2026/2027 TEST BANK EXAM
Review WITH FULL Solution AND Verified
Questions and Answers Verified Solutions Latest
Update
Question:
Which of the following can be populated by more than one package?
Answer:
A single table and a single row in a table.
Question:
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.
Question:
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers?
Answer:
Dictionary and the Dictionary editor.
Question:
True or False: Caboodle and Clarity can be used interchangeably?
Answer:
False. Caboodle and Clarity cannot be used interchangeably.
Question:
,Which of the following types of columns would you find in a type 1 table?
Answer:
Surrogate key, foreign key, and a combo key.
Question:
Where does Epic data in Caboodle come from?
Answer:
From Clarity, which gets its data from Chronicles.
Question:
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.
Question:
Caboodle is designed to.
Answer:
Store Epic data, store non-Epic data, make reporting easy, interoperate with SlicerDicer.
Question:
Caboodle is considered a normalized database.
Answer:
False
Question:
Name three documentation resources for Caboodle resources.
,Answer:
Caboodle dictionary, Reporting with Caboodle document, Caboodle ER diagram.
Question:
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.
Question:
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.
Question:
True or False: A new version of Caboodle is released every month.
Answer:
False, released every four to six months.
Question:
Explain the role of the Caboodle report writer.
Answer:
Queries data that already exists in the database.
Question:
Explain the role of the Caboodle administrator.
, Answer:
Uses the Caboodle console to mange and monitor the ETL process.
Question:
Explain the Caboodle developer role.
Answer:
Designs custom Data Model Components and SSIS packages to bring additional data into the data
warehouse.
Question:
True or False: Naming conventions are enforced in Caboodle.
Answer:
True. Naming conventions are enforced in Caboodle.
Question:
What is the relationship between SlicerDicer and Caboodle?
Answer:
SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically queries Caboodle
data.
Question:
What is the surrogate key for MedicationOrderFact?
Answer:
MedicationOrderKey
Question:
How are foreign keys documented in the Dictionary?
