CLR 110 CLARITY DATA MODEL FUNDAMENTALS NEWEST 2025/2026
ACTUAL EXAM QUESTIONS AND CORRECT DETAILED ANSWERS
Question 1
What is the very first step in the report writing process?
A. Choose a reporting tool.
B. Analyze the request for key features.
C. Write the SQL query.
D. Seed data in a test environment.
Correct Answer: B) Analyze the request for key features.
Rationale: Before any technical work begins, the report writer must first understand the
need. This involves analyzing who the report is for, what its purpose is, what data is needed,
and how it should be formatted.
Question 2
What is the most important decision a report writer makes during the report writing process?
A. How the data should be grouped.
B. Which reporting tool can best be used to meet the reporting need.
C. Which tables to include in the query.
D. How to format the final report.
Correct Answer: B) Which reporting tool can best be used to meet the reporting need.
Rationale: Selecting the correct tool (e.g., Reporting Workbench vs. Clarity/Crystal) is the
most critical decision because it determines whether the report will have the necessary
characteristics, such as being real-time or having the ability to handle large data sets.
Question 3
Which of the following are key characteristics of operational reports?
A. Comprehensive, summarized, and standardized
B. Time-sensitive, relatively small, and easily accessible
C. Historical, trend-focused, and integrated with non-Epic data
D. Real-time, large, and highly formatted
Correct Answer: B) Time-sensitive, relatively small, and easily accessible
,Rationale: Operational reports are used by end users to perform their jobs. They need to be
up-to-date (time-sensitive), return a manageable amount of data (relatively small), and be
integrated into their workflow (easily accessible and actionable).
Question 4
What is a key difference between operational and analytical reports?
A. Operational reports use Clarity, while analytical reports use Reporting Workbench.
B. Operational reports are real-time reports needed by end users, while analytical reports show
long-term trends.
C. Operational reports are for managers, while analytical reports are for front-line staff.
D. Operational reports are always text-based, while analytical reports are always graphical.
Correct Answer: B) Operational reports are real-time reports needed by end users, while
analytical reports show long-term trends.
Rationale: This is the fundamental distinction. Operational reports support immediate, day-
to-day tasks with real-time data. Analytical reports support strategic decisions by analyzing
historical data for trends and patterns.
Question 5
What is the primary reason to use Clarity for analytical reporting needs?
A. Clarity data is real-time.
B. Clarity reports can be run over very large data sets without slowing down the production
server.
C. Clarity reports are integrated into end-user workflows for interactive use.
D. Clarity is the only tool that can create a report.
Correct Answer: B) Clarity reports can be run over very large data sets without slowing
down the production server.
Rationale: Clarity data resides on a separate server. This allows for complex, resource-
intensive queries on large volumes of historical data without impacting the performance of
the live Chronicles production system used by clinicians.
Question 6
What is the most significant reason you should NOT use Clarity for operational reporting needs?
A. Clarity reports are too difficult to build.
,B. Clarity data is not real-time and is at least 24 hours out of date.
C. Clarity cannot be used with Crystal Reports.
D. Clarity reports can only show summarized data.
Correct Answer: B) Clarity data is not real-time and is at least 24 hours out of date.
Rationale: Operational decisions require current data. The ETL (Extract, Transform, Load)
process that moves data from Chronicles to Clarity typically runs only once a day, making
Clarity data inherently out-of-date and unsuitable for time-sensitive operational tasks.
Question 7
A user requests a report that is not available as a standard application report. Which reporting
tool should the report writer consider first for this operational need?
A. Caché Script
B. Clarity with Crystal Reports
C. A data warehouse
D. Reporting Workbench
Correct Answer: D) Reporting Workbench
Rationale: Reporting Workbench is Epic's primary user-facing tool for custom operational
reporting. It queries the live production database and can be used to create new reports
from scratch or modify existing templates.
Question 8
Is the following report request operational or analytical: "A count of the number of logs each
surgeon has documented in the past year, with the log ID, surgeon name, and primary
procedure."
A. Operational
B. Analytical
C. Both
D. Neither
Correct Answer: B) Analytical
Rationale: This report looks at a large amount of historical data (the past year) and
summarizes it (a count for each surgeon). These are key characteristics of an analytical
report.
, Question 9
A report request displays all patient encounters for patients under 18, grouped by provider,
showing patient and encounter details. The time frame is not specified. How would you classify
this report?
A. Strictly operational
B. Strictly analytical
C. Could be either operational or analytical depending on the time frame
D. This report cannot be built in Epic.
Correct Answer: C) Could be either operational or analytical depending on the time frame
Rationale: Without a defined time frame, the report is ambiguous. If the requester needs
data for the last 24 hours, it's an operational need. If they need data for the last five years,
it's an analytical need. The time frame is a critical factor.
Question 10
A user wants a report of pending departmental transfers. Is this an operational or analytical need?
A. Operational
B. Analytical
C. Both
D. Neither
Correct Answer: A) Operational
Rationale: "Pending" implies a current, actionable status. This is a time-sensitive report
that front-line staff would use to manage their immediate workflow, making it an
operational report.
Question 11
Which reporting tool is integrated into Epic's applications as part of the workflow and is most
familiar to end users?
A. Reporting Workbench
B. Crystal Reports
C. Application Reports
D. Caché Script
Correct Answer: C) Application Reports
ACTUAL EXAM QUESTIONS AND CORRECT DETAILED ANSWERS
Question 1
What is the very first step in the report writing process?
A. Choose a reporting tool.
B. Analyze the request for key features.
C. Write the SQL query.
D. Seed data in a test environment.
Correct Answer: B) Analyze the request for key features.
Rationale: Before any technical work begins, the report writer must first understand the
need. This involves analyzing who the report is for, what its purpose is, what data is needed,
and how it should be formatted.
Question 2
What is the most important decision a report writer makes during the report writing process?
A. How the data should be grouped.
B. Which reporting tool can best be used to meet the reporting need.
C. Which tables to include in the query.
D. How to format the final report.
Correct Answer: B) Which reporting tool can best be used to meet the reporting need.
Rationale: Selecting the correct tool (e.g., Reporting Workbench vs. Clarity/Crystal) is the
most critical decision because it determines whether the report will have the necessary
characteristics, such as being real-time or having the ability to handle large data sets.
Question 3
Which of the following are key characteristics of operational reports?
A. Comprehensive, summarized, and standardized
B. Time-sensitive, relatively small, and easily accessible
C. Historical, trend-focused, and integrated with non-Epic data
D. Real-time, large, and highly formatted
Correct Answer: B) Time-sensitive, relatively small, and easily accessible
,Rationale: Operational reports are used by end users to perform their jobs. They need to be
up-to-date (time-sensitive), return a manageable amount of data (relatively small), and be
integrated into their workflow (easily accessible and actionable).
Question 4
What is a key difference between operational and analytical reports?
A. Operational reports use Clarity, while analytical reports use Reporting Workbench.
B. Operational reports are real-time reports needed by end users, while analytical reports show
long-term trends.
C. Operational reports are for managers, while analytical reports are for front-line staff.
D. Operational reports are always text-based, while analytical reports are always graphical.
Correct Answer: B) Operational reports are real-time reports needed by end users, while
analytical reports show long-term trends.
Rationale: This is the fundamental distinction. Operational reports support immediate, day-
to-day tasks with real-time data. Analytical reports support strategic decisions by analyzing
historical data for trends and patterns.
Question 5
What is the primary reason to use Clarity for analytical reporting needs?
A. Clarity data is real-time.
B. Clarity reports can be run over very large data sets without slowing down the production
server.
C. Clarity reports are integrated into end-user workflows for interactive use.
D. Clarity is the only tool that can create a report.
Correct Answer: B) Clarity reports can be run over very large data sets without slowing
down the production server.
Rationale: Clarity data resides on a separate server. This allows for complex, resource-
intensive queries on large volumes of historical data without impacting the performance of
the live Chronicles production system used by clinicians.
Question 6
What is the most significant reason you should NOT use Clarity for operational reporting needs?
A. Clarity reports are too difficult to build.
,B. Clarity data is not real-time and is at least 24 hours out of date.
C. Clarity cannot be used with Crystal Reports.
D. Clarity reports can only show summarized data.
Correct Answer: B) Clarity data is not real-time and is at least 24 hours out of date.
Rationale: Operational decisions require current data. The ETL (Extract, Transform, Load)
process that moves data from Chronicles to Clarity typically runs only once a day, making
Clarity data inherently out-of-date and unsuitable for time-sensitive operational tasks.
Question 7
A user requests a report that is not available as a standard application report. Which reporting
tool should the report writer consider first for this operational need?
A. Caché Script
B. Clarity with Crystal Reports
C. A data warehouse
D. Reporting Workbench
Correct Answer: D) Reporting Workbench
Rationale: Reporting Workbench is Epic's primary user-facing tool for custom operational
reporting. It queries the live production database and can be used to create new reports
from scratch or modify existing templates.
Question 8
Is the following report request operational or analytical: "A count of the number of logs each
surgeon has documented in the past year, with the log ID, surgeon name, and primary
procedure."
A. Operational
B. Analytical
C. Both
D. Neither
Correct Answer: B) Analytical
Rationale: This report looks at a large amount of historical data (the past year) and
summarizes it (a count for each surgeon). These are key characteristics of an analytical
report.
, Question 9
A report request displays all patient encounters for patients under 18, grouped by provider,
showing patient and encounter details. The time frame is not specified. How would you classify
this report?
A. Strictly operational
B. Strictly analytical
C. Could be either operational or analytical depending on the time frame
D. This report cannot be built in Epic.
Correct Answer: C) Could be either operational or analytical depending on the time frame
Rationale: Without a defined time frame, the report is ambiguous. If the requester needs
data for the last 24 hours, it's an operational need. If they need data for the last five years,
it's an analytical need. The time frame is a critical factor.
Question 10
A user wants a report of pending departmental transfers. Is this an operational or analytical need?
A. Operational
B. Analytical
C. Both
D. Neither
Correct Answer: A) Operational
Rationale: "Pending" implies a current, actionable status. This is a time-sensitive report
that front-line staff would use to manage their immediate workflow, making it an
operational report.
Question 11
Which reporting tool is integrated into Epic's applications as part of the workflow and is most
familiar to end users?
A. Reporting Workbench
B. Crystal Reports
C. Application Reports
D. Caché Script
Correct Answer: C) Application Reports
