CDW 110v Caboodle Data Model
Fundamentals UPDATED Exam Questions
and CORRECT Answers
True or False: A caboodle report may contain at most 1 conformed dimension? - CORRECT
ANSWER- False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - CORRECT
ANSWER- A single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - CORRECT 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?
- CORRECT ANSWER- Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - CORRECT ANSWER-
False. Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - CORRECT
ANSWER- Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - CORRECT 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? -
CORRECT ANSWER- False. Caboodle developers can also SSIS packages to move data
from Clarity to Caboodle.
Caboodle is designed to... - CORRECT ANSWER- Store Epic data, store non-Epic data,
make reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - CORRECT ANSWER- False
,Name three documentation resources for Caboodle resources. - CORRECT 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? - CORRECT ANSWER- Because the console can be highly
customized for your organization.
What are the differences between a normalized and dimensional data model? - CORRECT
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. - CORRECT ANSWER-
False, released every four to six months.
Explain the role of the Caboodle report writer. - CORRECT ANSWER- Queries data that
already exists in the database.
Explain the role of the Caboodle administrator. - CORRECT ANSWER- Uses the Caboodle
console to mange and monitor the ETL process.
Explain the Caboodle developer role. - CORRECT ANSWER- 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 ANSWER- True.
Naming conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - CORRECT ANSWER-
SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically queries
Caboodle data.
What is the surrogate key for MedicationOrderFact? - CORRECT ANSWER-
MedicationOrderKey
, How are foreign keys documented in the Dictionary? - CORRECT ANSWER- 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 ANSWER- False. Multiple foreign keys can exist between two tables in
Caboodle.
How can MedicationOrderFact join to PatientDim? - CORRECT ANSWER-
MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - CORRECT ANSWER- Yes,
example MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - CORRECT
ANSWER- Users and Diagnosis Definitions
Which of the following are possible to do in Caboodle? - CORRECT ANSWER- 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 ANSWER- 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 ANSWER- 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 ANSWER- 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 UPDATED Exam Questions
and CORRECT Answers
True or False: A caboodle report may contain at most 1 conformed dimension? - CORRECT
ANSWER- False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - CORRECT
ANSWER- A single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - CORRECT 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?
- CORRECT ANSWER- Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - CORRECT ANSWER-
False. Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - CORRECT
ANSWER- Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - CORRECT 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? -
CORRECT ANSWER- False. Caboodle developers can also SSIS packages to move data
from Clarity to Caboodle.
Caboodle is designed to... - CORRECT ANSWER- Store Epic data, store non-Epic data,
make reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - CORRECT ANSWER- False
,Name three documentation resources for Caboodle resources. - CORRECT 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? - CORRECT ANSWER- Because the console can be highly
customized for your organization.
What are the differences between a normalized and dimensional data model? - CORRECT
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. - CORRECT ANSWER-
False, released every four to six months.
Explain the role of the Caboodle report writer. - CORRECT ANSWER- Queries data that
already exists in the database.
Explain the role of the Caboodle administrator. - CORRECT ANSWER- Uses the Caboodle
console to mange and monitor the ETL process.
Explain the Caboodle developer role. - CORRECT ANSWER- 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 ANSWER- True.
Naming conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - CORRECT ANSWER-
SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically queries
Caboodle data.
What is the surrogate key for MedicationOrderFact? - CORRECT ANSWER-
MedicationOrderKey
, How are foreign keys documented in the Dictionary? - CORRECT ANSWER- 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 ANSWER- False. Multiple foreign keys can exist between two tables in
Caboodle.
How can MedicationOrderFact join to PatientDim? - CORRECT ANSWER-
MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - CORRECT ANSWER- Yes,
example MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - CORRECT
ANSWER- Users and Diagnosis Definitions
Which of the following are possible to do in Caboodle? - CORRECT ANSWER- 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 ANSWER- 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 ANSWER- 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 ANSWER- 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.
