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