Exam Instructions
• Total Questions: 200
• Time Allowed: 3 Hours
• Select the BEST answer for each question
• Each question is worth 1 point
SECTION 1: EPIC DATABASES & DATA ARCHITECTURE
(Questions 1-25)
Question 1
Which database stores live, real-time transactional data in a hierarchical
format?
A. Clarity
B. Caboodle
C. Chronicles
D. Cogito Data Mart
Answer: C. Chronicles
,Rationale: Chronicles is Epic's production database. It stores data as users
interact with the system (e.g., placing orders, documenting vitals). Clarity and
Caboodle are data warehouses updated nightly .
Question 2
How often does the Clarity ETL process typically run?
A. Every 15 minutes
B. Every hour
C. Daily (nightly)
D. Weekly
Answer: C. Daily (nightly)
Rationale: The Clarity ETL runs nightly to extract data from Chronicles,
transform it, and load it into the Clarity relational database. This ensures
minimal impact on production performance .
Question 3
Which of Epic's databases are relational databases?
A. Chronicles only
B. Clarity and Caboodle
C. Caboodle only
D. Chronicles and Clarity
Answer: B. Clarity and Caboodle
Rationale: Clarity and Caboodle are both relational databases. Chronicles is
a hierarchical database .
, Question 4
A user needs to analyze 5 years of diabetes HbA1c trends across 20 clinics.
Which tool is most appropriate?
A. Radar
B. SlicerDicer
C. Reporting Workbench
D. Chronicles
Answer: B. SlicerDicer
Rationale: SlicerDicer is designed for self-service, historical, aggregated
analytics. It excels at trend analysis over long time periods across multiple
locations .
Question 5
What is the primary purpose of Caboodle?
A. Collecting real-time logs from Chronicles
B. Managing end-user security for Radar
C. Serving as an enterprise data warehouse for longitudinal reporting
D. Displaying registry dashboards
Answer: C. Serving as an enterprise data warehouse for longitudinal
reporting
Rationale: Caboodle is Epic's enterprise data warehouse that integrates and
stores data from Clarity and other sources for historical and predictive
analytics .
Question 6
Clarity is best described as: