1
CDW110V CABOODLE DATA MODEL FUNDAMENTALS QUESTIONS AND ANSWERS
True or False: A caboodle report may contain at most 1 conformed dimension? -
ASNWER-False. A Caboodle report can contain multiple conformed dimensions.
Define "Conformed dimension" - ASNWER-There are many fact DMC's in
Caboodle. Rather than define a complete set of dimensions for each, it's wise to
reuse them wherever possible. For example, most fact DMC's require a dimension
describing patients, and they all reference the same table (PatientDim) to do so.
Dimensions that provide context to multiple facts in this way are said to be
conformed dimensions.
Define "Profile dimension" - ASNWER-A "Profile Dimension" holds dimensional
data that is specific to a single fact DMC.
Define " Surrogate key" - ASNWER-represents an entity in a moment in time.
Define "Durable key" - ASNWER-Every type 2 DMC has a column named
DurableKey. This column contains the same value for all the rows that belong to a
,2
specific entity. For example, in PatientDim, all the rows corresponding to a specific
patient will have the same durable key. (each row will have a unique surrogate
key)
True or False: Caboodle and Clarity can be used interchangeably? - ASNWER-False.
Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? -
ASNWER-Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ASNWER-From Clarity, which gets
its data from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to
Caboodle? - ASNWER-False. Caboodle developers can also SSIS packages to move
data from Clarity to Caboodle.
Caboodle is designed to... - ASNWER-Store Epic data, store non-Epic data, make
reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ASNWER-False
Name three documentation resources for Caboodle resources. - ASNWER-
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? - ASNWER-Because the console can be
highly customized for your organization.
, 3
What are the differences between a normalized and dimensional data model? -
ASNWER-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. - ASNWER-
False, released every four to six months.
Explain the role of the Caboodle report writer. - ASNWER-Queries data that
already exists in the database.
Explain the role of the Caboodle administrator. - ASNWER-Uses the Caboodle
console to mange and monitor the ETL process.
Explain the Caboodle developer role. - ASNWER-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. - ASNWER-True.
Naming conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - ASNWER-SlicerDicer
is Epic's self service reporting tool in Hyperspace that dynamically queries
Caboodle data.
Which of the following can be populated by more than one package? - ASNWER-A
single table and a single row in a table.
CDW110V CABOODLE DATA MODEL FUNDAMENTALS QUESTIONS AND ANSWERS
True or False: A caboodle report may contain at most 1 conformed dimension? -
ASNWER-False. A Caboodle report can contain multiple conformed dimensions.
Define "Conformed dimension" - ASNWER-There are many fact DMC's in
Caboodle. Rather than define a complete set of dimensions for each, it's wise to
reuse them wherever possible. For example, most fact DMC's require a dimension
describing patients, and they all reference the same table (PatientDim) to do so.
Dimensions that provide context to multiple facts in this way are said to be
conformed dimensions.
Define "Profile dimension" - ASNWER-A "Profile Dimension" holds dimensional
data that is specific to a single fact DMC.
Define " Surrogate key" - ASNWER-represents an entity in a moment in time.
Define "Durable key" - ASNWER-Every type 2 DMC has a column named
DurableKey. This column contains the same value for all the rows that belong to a
,2
specific entity. For example, in PatientDim, all the rows corresponding to a specific
patient will have the same durable key. (each row will have a unique surrogate
key)
True or False: Caboodle and Clarity can be used interchangeably? - ASNWER-False.
Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? -
ASNWER-Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ASNWER-From Clarity, which gets
its data from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to
Caboodle? - ASNWER-False. Caboodle developers can also SSIS packages to move
data from Clarity to Caboodle.
Caboodle is designed to... - ASNWER-Store Epic data, store non-Epic data, make
reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ASNWER-False
Name three documentation resources for Caboodle resources. - ASNWER-
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? - ASNWER-Because the console can be
highly customized for your organization.
, 3
What are the differences between a normalized and dimensional data model? -
ASNWER-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. - ASNWER-
False, released every four to six months.
Explain the role of the Caboodle report writer. - ASNWER-Queries data that
already exists in the database.
Explain the role of the Caboodle administrator. - ASNWER-Uses the Caboodle
console to mange and monitor the ETL process.
Explain the Caboodle developer role. - ASNWER-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. - ASNWER-True.
Naming conventions are enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - ASNWER-SlicerDicer
is Epic's self service reporting tool in Hyperspace that dynamically queries
Caboodle data.
Which of the following can be populated by more than one package? - ASNWER-A
single table and a single row in a table.
