CDW110V CABOODLE DATA MODEL
FUNDAMENTALS ACTUAL PAPER 2026
QUESTIONS WITH ANSWERS GRADED 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.
>> 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.
FUNDAMENTALS ACTUAL PAPER 2026
QUESTIONS WITH ANSWERS GRADED 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.
>> 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.
