CDW110v Caboodle Data Model
Fundamentals | Complete Q&A Review with
Accurate Verified Answers | Graded A+
• Which of the following can be populated by more than one package? -
✓✓A single table and a single row in a table.
• When would a foreign key column in Caboodle contain a -1? -
✓✓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? -✓✓Dictionary and the Dictionary editor.
• True or False: Caboodle and Clarity can be used interchangeably? -
✓✓False. Caboodle and Clarity cannot be used interchangeably.
• Which of the following types of columns would you find in a type 1
table? -✓✓Surrogate key, foreign key, and a combo key.
• Where does Epic data in Caboodle come from? -✓✓From Clarity,
which gets its data from Chronicles.
,• True or false: Only Epic can define SSIS packages to move data from
Clarity to Caboodle? -✓✓False. Caboodle developers can also SSIS
packages to move data from Clarity to Caboodle.
• Caboodle is designed to... -✓✓Store Epic data, store non-Epic data,
make reporting easy, interoperate with SlicerDicer.
• Caboodle is considered a normalized database. -✓✓False
• Name three documentation resources for Caboodle resources. -
✓✓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? -✓✓Because
the console can be highly customized for your organization.
• What are the differences between a normalized and dimensional data
model? -✓✓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. -
✓✓False, released every four to six months.
, • Explain the role of the Caboodle report writer. -✓✓Queries data that
already exists in the database.
• Explain the role of the Caboodle administrator. -✓✓Uses the Caboodle
console to mange and monitor the ETL process.
• Explain the Caboodle developer role. -✓✓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. -
✓✓True. Naming conventions are enforced in Caboodle.
• What is the relationship between SlicerDicer and Caboodle? -
✓✓SlicerDicer is Epic's self service reporting tool in Hyperspace that
dynamically queries Caboodle data.
• What is the surrogate key for MedicationOrderFact? -
✓✓MedicationOrderKey
• How are foreign keys documented in the Dictionary? -✓✓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.
Fundamentals | Complete Q&A Review with
Accurate Verified Answers | Graded A+
• Which of the following can be populated by more than one package? -
✓✓A single table and a single row in a table.
• When would a foreign key column in Caboodle contain a -1? -
✓✓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? -✓✓Dictionary and the Dictionary editor.
• True or False: Caboodle and Clarity can be used interchangeably? -
✓✓False. Caboodle and Clarity cannot be used interchangeably.
• Which of the following types of columns would you find in a type 1
table? -✓✓Surrogate key, foreign key, and a combo key.
• Where does Epic data in Caboodle come from? -✓✓From Clarity,
which gets its data from Chronicles.
,• True or false: Only Epic can define SSIS packages to move data from
Clarity to Caboodle? -✓✓False. Caboodle developers can also SSIS
packages to move data from Clarity to Caboodle.
• Caboodle is designed to... -✓✓Store Epic data, store non-Epic data,
make reporting easy, interoperate with SlicerDicer.
• Caboodle is considered a normalized database. -✓✓False
• Name three documentation resources for Caboodle resources. -
✓✓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? -✓✓Because
the console can be highly customized for your organization.
• What are the differences between a normalized and dimensional data
model? -✓✓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. -
✓✓False, released every four to six months.
, • Explain the role of the Caboodle report writer. -✓✓Queries data that
already exists in the database.
• Explain the role of the Caboodle administrator. -✓✓Uses the Caboodle
console to mange and monitor the ETL process.
• Explain the Caboodle developer role. -✓✓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. -
✓✓True. Naming conventions are enforced in Caboodle.
• What is the relationship between SlicerDicer and Caboodle? -
✓✓SlicerDicer is Epic's self service reporting tool in Hyperspace that
dynamically queries Caboodle data.
• What is the surrogate key for MedicationOrderFact? -
✓✓MedicationOrderKey
• How are foreign keys documented in the Dictionary? -✓✓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.
