CDW 110V CABOODLE DATA
FUNDAMENTALS MODEL EXAM WITH
CORRECT ACTUAL QUESTIONS AND
ANSWERS
True or False: Caboodle and Clarity can be used interchangeably? - correct answers-False. Caboodle
and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - correct answers-
Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - correct answers-From Clarity, which gets its data
from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? - correct
answers-False. Caboodle developers can also SSIS packages to move data from Clarity to Caboodle.
Caboodle is designed to... - correct answers-Store Epic data, store non-Epic data, make reporting
easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - correct answers-False
Name three documentation resources for Caboodle resources. - correct answers-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? - correct answers-Because the console can be highly customized for your
organization.
,What are the differences between a normalized and dimensional data model? - correct answers-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. - correct answers-False, released
every four to six months.
Explain the role of the Caboodle report writer. - correct answers-Queries data that already exists in
the database.
True or False: A caboodle report may contain at most 1 conformed dimension? - correct answers-
False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - correct answers-A single table
and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - correct answers-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? -
correct answers-Dictionary and the Dictionary editor.
Explain the role of the Caboodle administrator. - correct answers-Uses the Caboodle console to
mange and monitor the ETL process.
Explain the Caboodle developer role. - correct answers-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. - correct answers-True. Naming
conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - correct answers-SlicerDicer is Epic's
self service reporting tool in Hyperspace that dynamically queries Caboodle data.
, What is the surrogate key for MedicationOrderFact? - correct answers-MedicationOrderKey
How are foreign keys documented in the Dictionary? - correct answers-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. - correct
answers-False. Multiple foreign keys can exist between two tables in Caboodle.
How can MedicationOrderFact join to PatientDim? - correct answers-
MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - correct answers-Yes, example
MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - correct answers-Users
and Diagnosis Definitions
Which of the following are possible to do in Caboodle? - correct answers-Joining a fact table to
another fact table, Fact table to dimension table, dimension table to dimension table, 2 different
EAV dim table to an attribute dim table
True or False: Any change to Patient data in Clarity will generate a new row in PatientDim after the
next extract. - correct answers-False, only changes in type 2 data would result in a new row being
generated.
True of false: The _Current view tables in the FullAccess schema contains a subset of the rows
contained in their corresponding type 2 tables. - correct answers-True. _Current view tables in the
Fullaccess schema contain a subset of the rows contained in their corresponding type 2 tables.
What is a durable key? - correct answers-Type 2 tables have a durable key column which stores the
same value for all rows that correspond to the same entity. This allows for grouping or summarizing
data by the entity.
FUNDAMENTALS MODEL EXAM WITH
CORRECT ACTUAL QUESTIONS AND
ANSWERS
True or False: Caboodle and Clarity can be used interchangeably? - correct answers-False. Caboodle
and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - correct answers-
Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - correct answers-From Clarity, which gets its data
from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? - correct
answers-False. Caboodle developers can also SSIS packages to move data from Clarity to Caboodle.
Caboodle is designed to... - correct answers-Store Epic data, store non-Epic data, make reporting
easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - correct answers-False
Name three documentation resources for Caboodle resources. - correct answers-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? - correct answers-Because the console can be highly customized for your
organization.
,What are the differences between a normalized and dimensional data model? - correct answers-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. - correct answers-False, released
every four to six months.
Explain the role of the Caboodle report writer. - correct answers-Queries data that already exists in
the database.
True or False: A caboodle report may contain at most 1 conformed dimension? - correct answers-
False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - correct answers-A single table
and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - correct answers-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? -
correct answers-Dictionary and the Dictionary editor.
Explain the role of the Caboodle administrator. - correct answers-Uses the Caboodle console to
mange and monitor the ETL process.
Explain the Caboodle developer role. - correct answers-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. - correct answers-True. Naming
conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - correct answers-SlicerDicer is Epic's
self service reporting tool in Hyperspace that dynamically queries Caboodle data.
, What is the surrogate key for MedicationOrderFact? - correct answers-MedicationOrderKey
How are foreign keys documented in the Dictionary? - correct answers-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. - correct
answers-False. Multiple foreign keys can exist between two tables in Caboodle.
How can MedicationOrderFact join to PatientDim? - correct answers-
MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - correct answers-Yes, example
MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - correct answers-Users
and Diagnosis Definitions
Which of the following are possible to do in Caboodle? - correct answers-Joining a fact table to
another fact table, Fact table to dimension table, dimension table to dimension table, 2 different
EAV dim table to an attribute dim table
True or False: Any change to Patient data in Clarity will generate a new row in PatientDim after the
next extract. - correct answers-False, only changes in type 2 data would result in a new row being
generated.
True of false: The _Current view tables in the FullAccess schema contains a subset of the rows
contained in their corresponding type 2 tables. - correct answers-True. _Current view tables in the
Fullaccess schema contain a subset of the rows contained in their corresponding type 2 tables.
What is a durable key? - correct answers-Type 2 tables have a durable key column which stores the
same value for all rows that correspond to the same entity. This allows for grouping or summarizing
data by the entity.
