EPIC COGITO FUNDAMENTALS
(COG170) : QUESTIONS AND
RATIONALES/Graded A+ UPDATE
100% CORRECT
SECTION 1: CORE DATA ARCHITECTURE (Questions 1-15)
1. Which of Epic's databases contains real-time, transactional data used for daily
clinical documentation and patient management?
• A) Clarity
• B) Caboodle
• C) Chronicles
• D) Cogito Data Mart
Rationale: Chronicles is Epic's production hierarchical database that stores all live,
real-time data including clinical, billing, and user information. Clarity and Caboodle
are updated nightly and are not real-time sources.
2. A healthcare system wants to perform a complex SQL query combining Epic data
with external data from a third-party wearable device for long-term trend analysis.
Which database is best suited for this task?
, • A) Chronicles
• B) Clarity
• C) Caboodle
• D) Reporting Workbench
Rationale: Caboodle is Epic's enterprise data warehouse (EDW) specifically designed
to integrate Epic data with third-party sources for longitudinal and historical
analytics.
3. What is the name of the automated process that extracts data from Chronicles and
loads it into Clarity?
• A) Shadowing
• B) Slicing
• C) ETL (Extract, Transform, Load)
• D) Mirroring
Rationale: The ETL process, typically running nightly, moves operational data from
the hierarchical Chronicles database into the relational Clarity database to support
complex reporting.
4. Which statement correctly describes the update frequency for data in the Clarity
database?
• A) Real-time, as soon as a doctor signs a note.
• B) Every 15 minutes via a continuous data stream.
• C) Updated nightly during the ETL business process.
• D) Manually, triggered by an analyst.
Rationale: Data in Clarity is updated once per day during the Clarity ETL process. It
is always at least 24 hours behind real-time operations, making it suitable for non-
real-time analytics.
5. A manager needs to see a live list of patients currently in the emergency
department waiting room. Which tool should be used to access this real-time data?
• A) A Clarity SQL Report
• B) SlicerDicer
• C) Reporting Workbench
• D) Caboodle Data Model
Rationale: Reporting Workbench is the only standard reporting tool that can query
data directly from the real-time Chronicles database, making it appropriate for live
operational dashboards.
6. Which of the following databases are relational (SQL-based)? (Select all that apply)
, • A) Chronicles
• B) Clarity
• C) Caboodle
• D) Radar
Rationale: Clarity and Caboodle are relational, SQL-based databases. Chronicles is a
hierarchical database, while Radar is a dashboard tool, not a database.
7. True or False: Data in the Caboodle warehouse is updated multiple times per hour
to support real-time decision making.
• A) True
• B) False
Rationale: This is False. While Caboodle supports near-real-time analytics through
real-time Caboodle (RTC), the core traditional Caboodle warehouse is typically
updated in batches (nightly) or via near-real-time feeds depending on system
configuration, but it is primarily used for historical/longitudinal analysis, not true
real-time.
8. Which database serves as the foundation for the SlicerDicer interactive analytics
tool?
• A) Chronicles
• B) Clarity
• C) Caboodle
• D) Radar
Rationale: SlicerDicer is an analytical exploration tool that sits on top of the
Caboodle data warehouse structure to enable self-service data discovery.
9. An analyst writes a report combining data from the ADT (Admission, Discharge,
Transfer) table and the billing system. These tables exist in a relational format
suitable for complex joins. Which database is the report most likely sourced from?
• A) Chronicles
• B) Clarity
• C) SlicerDicer
• D) Hyperspace
Rationale: Clarity contains relational, SQL-based tables that are specifically designed
for complex, join-intensive reporting. Chronicles is hierarchical and not ideal for
standard SQL joins.
10. What is the primary purpose of the Chronicles database?
(COG170) : QUESTIONS AND
RATIONALES/Graded A+ UPDATE
100% CORRECT
SECTION 1: CORE DATA ARCHITECTURE (Questions 1-15)
1. Which of Epic's databases contains real-time, transactional data used for daily
clinical documentation and patient management?
• A) Clarity
• B) Caboodle
• C) Chronicles
• D) Cogito Data Mart
Rationale: Chronicles is Epic's production hierarchical database that stores all live,
real-time data including clinical, billing, and user information. Clarity and Caboodle
are updated nightly and are not real-time sources.
2. A healthcare system wants to perform a complex SQL query combining Epic data
with external data from a third-party wearable device for long-term trend analysis.
Which database is best suited for this task?
, • A) Chronicles
• B) Clarity
• C) Caboodle
• D) Reporting Workbench
Rationale: Caboodle is Epic's enterprise data warehouse (EDW) specifically designed
to integrate Epic data with third-party sources for longitudinal and historical
analytics.
3. What is the name of the automated process that extracts data from Chronicles and
loads it into Clarity?
• A) Shadowing
• B) Slicing
• C) ETL (Extract, Transform, Load)
• D) Mirroring
Rationale: The ETL process, typically running nightly, moves operational data from
the hierarchical Chronicles database into the relational Clarity database to support
complex reporting.
4. Which statement correctly describes the update frequency for data in the Clarity
database?
• A) Real-time, as soon as a doctor signs a note.
• B) Every 15 minutes via a continuous data stream.
• C) Updated nightly during the ETL business process.
• D) Manually, triggered by an analyst.
Rationale: Data in Clarity is updated once per day during the Clarity ETL process. It
is always at least 24 hours behind real-time operations, making it suitable for non-
real-time analytics.
5. A manager needs to see a live list of patients currently in the emergency
department waiting room. Which tool should be used to access this real-time data?
• A) A Clarity SQL Report
• B) SlicerDicer
• C) Reporting Workbench
• D) Caboodle Data Model
Rationale: Reporting Workbench is the only standard reporting tool that can query
data directly from the real-time Chronicles database, making it appropriate for live
operational dashboards.
6. Which of the following databases are relational (SQL-based)? (Select all that apply)
, • A) Chronicles
• B) Clarity
• C) Caboodle
• D) Radar
Rationale: Clarity and Caboodle are relational, SQL-based databases. Chronicles is a
hierarchical database, while Radar is a dashboard tool, not a database.
7. True or False: Data in the Caboodle warehouse is updated multiple times per hour
to support real-time decision making.
• A) True
• B) False
Rationale: This is False. While Caboodle supports near-real-time analytics through
real-time Caboodle (RTC), the core traditional Caboodle warehouse is typically
updated in batches (nightly) or via near-real-time feeds depending on system
configuration, but it is primarily used for historical/longitudinal analysis, not true
real-time.
8. Which database serves as the foundation for the SlicerDicer interactive analytics
tool?
• A) Chronicles
• B) Clarity
• C) Caboodle
• D) Radar
Rationale: SlicerDicer is an analytical exploration tool that sits on top of the
Caboodle data warehouse structure to enable self-service data discovery.
9. An analyst writes a report combining data from the ADT (Admission, Discharge,
Transfer) table and the billing system. These tables exist in a relational format
suitable for complex joins. Which database is the report most likely sourced from?
• A) Chronicles
• B) Clarity
• C) SlicerDicer
• D) Hyperspace
Rationale: Clarity contains relational, SQL-based tables that are specifically designed
for complex, join-intensive reporting. Chronicles is hierarchical and not ideal for
standard SQL joins.
10. What is the primary purpose of the Chronicles database?
