Epic Caboodle Data Model
Fundamentals: Certification Practice
Questions (100 MCQs)
Category 1: Clarity vs. Caboodle & Foundational Concepts (Q1-Q15)
1. What is the primary purpose of the Caboodle data model?
a) To serve as the transactional database for real-time Epic application usage.
b) To provide a normalized, source-agnostic data warehouse optimized for analytics and
reporting.
c) To replace the Clarity data model for all reporting purposes.
d) To act as the primary data entry system for clinical documentation.
Answer: b) To provide a normalized, source-agnostic data warehouse optimized for analytics
and reporting.
2. Which statement best describes the relationship between Clarity and Caboodle?
a) Caboodle is a direct copy of Clarity with faster query performance.
b) Caboodle is built by extracting and transforming data from Clarity and other sources.
c) Clarity is a summarized version of the detailed data found in Caboodle.
d) They are two independent databases with no direct relationship.
Answer: b) Caboodle is built by extracting and transforming data from Clarity and other
sources.
3. The process of moving data from Clarity into Caboodle is known as:
a) ETL (Extract, Transform, Load)
b) ELT (Extract, Load, Transform)
c) CDC (Change Data Capture)
d) API (Application Programming Interface)
Answer: a) ETL (Extract, Transform, Load)
4. A key architectural benefit of Caboodle is its use of a dimensional model. What is a major
advantage of this design?
a) It minimizes data storage requirements.
b) It simplifies and standardizes queries for end-users.
c) It eliminates the need for primary and foreign keys.
d) It allows for real-time data updates from the production environment.
Answer: b) It simplifies and standardizes queries for end-users.
,5. Which Epic component is primarily used to schedule and manage the ETL processes that
populate Caboodle?
a) Cogito SlicerDicer
b) Cogito SQL Server Management Studio (SSMS)
c) Cogito Data Warehouse (CDW) Console
d) Cogito Tools
Answer: c) Cogito Data Warehouse (CDW) Console
6. In the Caboodle architecture, what is the role of the "Stage" database?
a) To present data to end-users in SlicerDicer.
b) To hold the transformed, dimensional model ready for reporting.
c) To act as a temporary holding area for data extracted from source systems.
d) To store pre-built reports and dashboards.
Answer: c) To act as a temporary holding area for data extracted from source systems.
7. True or False: Caboodle only contains data from the Epic electronic health record (EHR).
a) True
b) False
Answer: b) False. Caboodle can integrate data from non-Epic sources (e.g., patient satisfaction
surveys, financial systems).
8. Which of the following is a core principle of the Caboodle data model's design?
a) Preserving the original table structure from the Chronicles database.
b) Being source-agnostic, so data from various sources is presented consistently.
c) Prioritizing data entry speed over query performance.
d) Requiring complex, multi-table joins for every query.
Answer: b) Being source-agnostic, so data from various sources is presented consistently.
9. The "Mart" database in the Caboodle architecture is best described as:
a) The transactional database.
b) The staging database.
c) The presentation database, containing fact and dimension tables.
d) The backup database.
Answer: c) The presentation database, containing fact and dimension tables.
10. What is the primary user interface for building reports and analyses on the Caboodle data
model?
a) Reporting Workbench
b) Clarity
c) SlicerDicer
, d) SSMS (SQL Server Management Studio)
Answer: c) SlicerDicer
11. Which database is typically queried by users writing custom SQL reports?
a) Chronicles
b) Clarity
c) Caboodle
d) Production
Answer: c) Caboodle
12. The initial load of data into Caboodle is a:
a) Differential load
b) Full load
c) Incremental load
d) Real-time load
Answer: b) Full load
13. After the initial load, subsequent data loads into Caboodle are typically:
a) Full loads that replace all existing data.
b) Incremental loads that only add new or changed data.
c) Manual data entry by analysts.
d) Real-time streams from the production database.
Answer: b) Incremental loads that only add new or changed data.
14. Which of these is NOT a common data source for Caboodle?
a) Epic Clarity
b) Third-party patient billing systems
c) Epic Hyperspace (real-time transactions)
d) Health Information Exchange (HIE) data
Answer: c) Epic Hyperspace (real-time transactions). Caboodle is fed from Clarity, not directly
from the transactional Hyperspace environment.
15. The conceptual process of aligning data from different source systems to a common
standard in Caboodle is called:
a) Data Conformance
b) Data Replication
c) Data Archiving
d) Data Encryption
Answer: a) Data Conformance
Fundamentals: Certification Practice
Questions (100 MCQs)
Category 1: Clarity vs. Caboodle & Foundational Concepts (Q1-Q15)
1. What is the primary purpose of the Caboodle data model?
a) To serve as the transactional database for real-time Epic application usage.
b) To provide a normalized, source-agnostic data warehouse optimized for analytics and
reporting.
c) To replace the Clarity data model for all reporting purposes.
d) To act as the primary data entry system for clinical documentation.
Answer: b) To provide a normalized, source-agnostic data warehouse optimized for analytics
and reporting.
2. Which statement best describes the relationship between Clarity and Caboodle?
a) Caboodle is a direct copy of Clarity with faster query performance.
b) Caboodle is built by extracting and transforming data from Clarity and other sources.
c) Clarity is a summarized version of the detailed data found in Caboodle.
d) They are two independent databases with no direct relationship.
Answer: b) Caboodle is built by extracting and transforming data from Clarity and other
sources.
3. The process of moving data from Clarity into Caboodle is known as:
a) ETL (Extract, Transform, Load)
b) ELT (Extract, Load, Transform)
c) CDC (Change Data Capture)
d) API (Application Programming Interface)
Answer: a) ETL (Extract, Transform, Load)
4. A key architectural benefit of Caboodle is its use of a dimensional model. What is a major
advantage of this design?
a) It minimizes data storage requirements.
b) It simplifies and standardizes queries for end-users.
c) It eliminates the need for primary and foreign keys.
d) It allows for real-time data updates from the production environment.
Answer: b) It simplifies and standardizes queries for end-users.
,5. Which Epic component is primarily used to schedule and manage the ETL processes that
populate Caboodle?
a) Cogito SlicerDicer
b) Cogito SQL Server Management Studio (SSMS)
c) Cogito Data Warehouse (CDW) Console
d) Cogito Tools
Answer: c) Cogito Data Warehouse (CDW) Console
6. In the Caboodle architecture, what is the role of the "Stage" database?
a) To present data to end-users in SlicerDicer.
b) To hold the transformed, dimensional model ready for reporting.
c) To act as a temporary holding area for data extracted from source systems.
d) To store pre-built reports and dashboards.
Answer: c) To act as a temporary holding area for data extracted from source systems.
7. True or False: Caboodle only contains data from the Epic electronic health record (EHR).
a) True
b) False
Answer: b) False. Caboodle can integrate data from non-Epic sources (e.g., patient satisfaction
surveys, financial systems).
8. Which of the following is a core principle of the Caboodle data model's design?
a) Preserving the original table structure from the Chronicles database.
b) Being source-agnostic, so data from various sources is presented consistently.
c) Prioritizing data entry speed over query performance.
d) Requiring complex, multi-table joins for every query.
Answer: b) Being source-agnostic, so data from various sources is presented consistently.
9. The "Mart" database in the Caboodle architecture is best described as:
a) The transactional database.
b) The staging database.
c) The presentation database, containing fact and dimension tables.
d) The backup database.
Answer: c) The presentation database, containing fact and dimension tables.
10. What is the primary user interface for building reports and analyses on the Caboodle data
model?
a) Reporting Workbench
b) Clarity
c) SlicerDicer
, d) SSMS (SQL Server Management Studio)
Answer: c) SlicerDicer
11. Which database is typically queried by users writing custom SQL reports?
a) Chronicles
b) Clarity
c) Caboodle
d) Production
Answer: c) Caboodle
12. The initial load of data into Caboodle is a:
a) Differential load
b) Full load
c) Incremental load
d) Real-time load
Answer: b) Full load
13. After the initial load, subsequent data loads into Caboodle are typically:
a) Full loads that replace all existing data.
b) Incremental loads that only add new or changed data.
c) Manual data entry by analysts.
d) Real-time streams from the production database.
Answer: b) Incremental loads that only add new or changed data.
14. Which of these is NOT a common data source for Caboodle?
a) Epic Clarity
b) Third-party patient billing systems
c) Epic Hyperspace (real-time transactions)
d) Health Information Exchange (HIE) data
Answer: c) Epic Hyperspace (real-time transactions). Caboodle is fed from Clarity, not directly
from the transactional Hyperspace environment.
15. The conceptual process of aligning data from different source systems to a common
standard in Caboodle is called:
a) Data Conformance
b) Data Replication
c) Data Archiving
d) Data Encryption
Answer: a) Data Conformance
