CDW 110v Caboodle Data Model Fundamentals-Questions with
Correct Answers/ Verified
True or False: A caboodle report may contain at most 1 conformed dimension? - ✔✔False. A
Caboodle report can contain multiple conformed dimensions.
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.
True or False: A maximum of one foreign key can exist between two tables in Caboodle. - ✔✔False.
Multiple foreign keys can exist between two tables in Caboodle.
, How can MedicationOrderFact join to PatientDim? - ✔✔MedicationOrderFact.PatientKey =
PatientDim.PatientKey or MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - ✔✔Yes, example MedicationOrderFact
can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - ✔✔Users and
Diagnosis Definitions
Which of the following are possible to do in Caboodle? - ✔✔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. - ✔✔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. - ✔✔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? - ✔✔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.
If a patient has a PCP assigned, but that providers' data hasn't been extracted to ProviderDim, what
value would appear in ProviderDim.name for this patient? - ✔✔*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3. What could this mean? - ✔✔Either the data
that once populated this row was deleted from the source, or this is the -3 row, for which all foreign
key columns are also -3.
If a foreign key is null in Clarity, what will appear in the corresponding column in Caboodle? - ✔✔If
the foreign key was expected to have data, then a -1 will appear in Caboodle to represent an
unspecified value. If the foreign key was not expected to contain data, then a -2 will appear in the
row to represent a value that is not applicable.
Correct Answers/ Verified
True or False: A caboodle report may contain at most 1 conformed dimension? - ✔✔False. A
Caboodle report can contain multiple conformed dimensions.
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.
True or False: A maximum of one foreign key can exist between two tables in Caboodle. - ✔✔False.
Multiple foreign keys can exist between two tables in Caboodle.
, How can MedicationOrderFact join to PatientDim? - ✔✔MedicationOrderFact.PatientKey =
PatientDim.PatientKey or MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - ✔✔Yes, example MedicationOrderFact
can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - ✔✔Users and
Diagnosis Definitions
Which of the following are possible to do in Caboodle? - ✔✔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. - ✔✔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. - ✔✔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? - ✔✔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.
If a patient has a PCP assigned, but that providers' data hasn't been extracted to ProviderDim, what
value would appear in ProviderDim.name for this patient? - ✔✔*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3. What could this mean? - ✔✔Either the data
that once populated this row was deleted from the source, or this is the -3 row, for which all foreign
key columns are also -3.
If a foreign key is null in Clarity, what will appear in the corresponding column in Caboodle? - ✔✔If
the foreign key was expected to have data, then a -1 will appear in Caboodle to represent an
unspecified value. If the foreign key was not expected to contain data, then a -2 will appear in the
row to represent a value that is not applicable.
