ACING CLR 110: EPIC CLARITY DATA MODEL
FUNDAMENTALS EXAM 200 PRACTICE QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)
GRADED A+
Section 1: Report Development Process (Questions 1-45)
This section tests your ability to analyze reporting requests, select the appropriate tool, and
distinguish between different report types. The report development process is the foundational
skill for any BID, as it sets the direction for all technical work that follows.
1. What is the very first step a Business Intelligence Developer (BID) should take
when receiving a new report request?
a) Immediately open Crystal Reports and begin designing the layout.
b) Analyze the request to identify who needs the report, its purpose, and how the
data should be formatted.
c) Request access to the Clarity database from the ETL Administrator.
d) Search the Epic UserWeb for an existing report.
Correct Answer: b) Analyze the request to identify who needs the report, its
purpose, and how the data should be formatted.
Rationale: Before any technical work begins, understanding the business need is
critical. The BID must ask foundational questions: Who needs it? What is its
purpose? How much data should it return? How up-to-date does the data need to
be? How should the data be formatted? This analysis prevents wasted effort and
ensures the final product truly meets the stakeholder's needs.
2. A clinician needs a report that displays a patient's current medications
immediately after a prescription is entered. Which type of report is required?
a) Analytical Report
b) Operational Report
c) Ad-hoc Report
d) Trend Analysis Report
Correct Answer: b) Operational Report
1|Page
,Rationale: Operational reports are characterized by being time-sensitive,
relatively small, easily accessible, and actionable. They are used for day-to-day
tasks and require real-time or near real-time data.
3. A data analyst needs to identify long-term trends in patient readmission rates
over the past five years. Which type of report is most appropriate?
a) Operational Report
b) Summary Report
c) Analytical Report
d) Real-time Report
Correct Answer: c) Analytical Report
Rationale: Analytical reports are designed to show long-term trends and data
over time. They allow users to analyze large datasets, find patterns, and support
strategic decision-making, unlike operational reports which focus on immediate,
real-time needs.
4. What is the most important decision in the report-writing process for a BID?
a) Choosing the color scheme for the report output.
b) Determining which reporting tool can best be used to meet the reporting need.
c) Identifying the primary key of the main Clarity table.
d) Writing the most efficient SQL query.
Correct Answer: b) Determining which reporting tool can best be used to meet
the reporting need.
Rationale: While all tasks are important, the tool selection determines the
report's feasibility, performance, and capabilities. Using the wrong tool (e.g.,
Clarity for a real-time report) will lead to a failed product, regardless of SQL
optimization.
5. In what scenario is it NOT mandatory to use the Clarity database?
a) When a pre-built application report cannot meet the need.
b) When reporting on large datasets that would slow down the production server.
c) When performing integrated reporting on both Epic and non-Epic data.
d) When a complex report needs to include groupings and mathematics.
Correct Answer: a) When a pre-built application report cannot meet the need.
2|Page
,Rationale: A non-standard reporting need does not automatically necessitate
using Clarity. Many intermediate needs can be met using other tools like
Reporting Workbench before escalating to the complexity of Clarity and SQL.
6. Which of the following is NOT a primary characteristic of an operational report?
a) Actionable
b) Time-sensitive
c) Highlights long-term trends
d) Relatively small
Correct Answer: c) Highlights long-term trends
Rationale: Highlighting long-term trends is a key characteristic of analytical
reports. Operational reports are focused on the immediate present to support
daily workflows.
7. A manager requests a count of all surgical logs by surgeon for the last 12
months, including the primary procedure. Is this operational or analytical?
a) Operational, because it's actionable.
b) Operational, because it involves counting.
c) Analytical, because it requires grouping and mathematics.
d) Analytical, because it analyzes data over a period of time to show a trend.
Correct Answer: d) Analytical, because it analyzes data over a period of time to
show a trend.
Rationale: The key indicator here is "over a period of time." The request is to
analyze a year's worth of data to understand each surgeon's volume, a task that
fits the definition of an analytical report.
8. A report is needed to list all emergency department encounters from the last
24 hours, showing patient name, arrival time, and discharge disposition. The
results must be available in near real-time to manage bed flow. What tool is most
likely appropriate?
a) Clarity
b) Reporting Workbench
c) Caboodle
d) SlicerDicer
3|Page
, Correct Answer: b) Reporting Workbench
Rationale: The requirement is for near real-time data. Clarity data is known to be
delayed, often by at least 24 hours, making it unsuitable for this need. Reporting
Workbench or another operational reporting tool would be a better fit.
9. If a report fails to meet a user's need, but the user cannot articulate the
required changes, what is the BID's best course of action?
a) Assume the report is correct and close the ticket.
b) Delete the report and start over from scratch.
c) Ask for a written list of data points, disregarding the user's workflow.
d) Re-analyze the request with the user, focusing on the purpose and required
actions.
Correct Answer: d) Re-analyze the request with the user, focusing on the purpose
and required actions.
Rationale: When communication breaks down, the BID should return to the initial
analysis phase. By refocusing on the report's purpose and how the user will act on
its output, the BID can often clarify requirements more effectively than by
focusing on technical specifications.
10. Your Epic application coordinator asks you for a list of all patients currently
admitted to the hospital. They need to use this list in their daily huddle to discuss
patient flow. What type of report is this?
a) Analytical
b) Clinical
c) Operational
d) Historical
Correct Answer: c) Operational
Rationale: This request is for a current-state list used for an immediate, daily task.
It is time-sensitive and actionable, fitting the definition of an operational report.
11. Which of the following is a core characteristic of operational reports?
a) They show data over an extended time.
b) They are often used for regulatory reporting.
4|Page
FUNDAMENTALS EXAM 200 PRACTICE QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)
GRADED A+
Section 1: Report Development Process (Questions 1-45)
This section tests your ability to analyze reporting requests, select the appropriate tool, and
distinguish between different report types. The report development process is the foundational
skill for any BID, as it sets the direction for all technical work that follows.
1. What is the very first step a Business Intelligence Developer (BID) should take
when receiving a new report request?
a) Immediately open Crystal Reports and begin designing the layout.
b) Analyze the request to identify who needs the report, its purpose, and how the
data should be formatted.
c) Request access to the Clarity database from the ETL Administrator.
d) Search the Epic UserWeb for an existing report.
Correct Answer: b) Analyze the request to identify who needs the report, its
purpose, and how the data should be formatted.
Rationale: Before any technical work begins, understanding the business need is
critical. The BID must ask foundational questions: Who needs it? What is its
purpose? How much data should it return? How up-to-date does the data need to
be? How should the data be formatted? This analysis prevents wasted effort and
ensures the final product truly meets the stakeholder's needs.
2. A clinician needs a report that displays a patient's current medications
immediately after a prescription is entered. Which type of report is required?
a) Analytical Report
b) Operational Report
c) Ad-hoc Report
d) Trend Analysis Report
Correct Answer: b) Operational Report
1|Page
,Rationale: Operational reports are characterized by being time-sensitive,
relatively small, easily accessible, and actionable. They are used for day-to-day
tasks and require real-time or near real-time data.
3. A data analyst needs to identify long-term trends in patient readmission rates
over the past five years. Which type of report is most appropriate?
a) Operational Report
b) Summary Report
c) Analytical Report
d) Real-time Report
Correct Answer: c) Analytical Report
Rationale: Analytical reports are designed to show long-term trends and data
over time. They allow users to analyze large datasets, find patterns, and support
strategic decision-making, unlike operational reports which focus on immediate,
real-time needs.
4. What is the most important decision in the report-writing process for a BID?
a) Choosing the color scheme for the report output.
b) Determining which reporting tool can best be used to meet the reporting need.
c) Identifying the primary key of the main Clarity table.
d) Writing the most efficient SQL query.
Correct Answer: b) Determining which reporting tool can best be used to meet
the reporting need.
Rationale: While all tasks are important, the tool selection determines the
report's feasibility, performance, and capabilities. Using the wrong tool (e.g.,
Clarity for a real-time report) will lead to a failed product, regardless of SQL
optimization.
5. In what scenario is it NOT mandatory to use the Clarity database?
a) When a pre-built application report cannot meet the need.
b) When reporting on large datasets that would slow down the production server.
c) When performing integrated reporting on both Epic and non-Epic data.
d) When a complex report needs to include groupings and mathematics.
Correct Answer: a) When a pre-built application report cannot meet the need.
2|Page
,Rationale: A non-standard reporting need does not automatically necessitate
using Clarity. Many intermediate needs can be met using other tools like
Reporting Workbench before escalating to the complexity of Clarity and SQL.
6. Which of the following is NOT a primary characteristic of an operational report?
a) Actionable
b) Time-sensitive
c) Highlights long-term trends
d) Relatively small
Correct Answer: c) Highlights long-term trends
Rationale: Highlighting long-term trends is a key characteristic of analytical
reports. Operational reports are focused on the immediate present to support
daily workflows.
7. A manager requests a count of all surgical logs by surgeon for the last 12
months, including the primary procedure. Is this operational or analytical?
a) Operational, because it's actionable.
b) Operational, because it involves counting.
c) Analytical, because it requires grouping and mathematics.
d) Analytical, because it analyzes data over a period of time to show a trend.
Correct Answer: d) Analytical, because it analyzes data over a period of time to
show a trend.
Rationale: The key indicator here is "over a period of time." The request is to
analyze a year's worth of data to understand each surgeon's volume, a task that
fits the definition of an analytical report.
8. A report is needed to list all emergency department encounters from the last
24 hours, showing patient name, arrival time, and discharge disposition. The
results must be available in near real-time to manage bed flow. What tool is most
likely appropriate?
a) Clarity
b) Reporting Workbench
c) Caboodle
d) SlicerDicer
3|Page
, Correct Answer: b) Reporting Workbench
Rationale: The requirement is for near real-time data. Clarity data is known to be
delayed, often by at least 24 hours, making it unsuitable for this need. Reporting
Workbench or another operational reporting tool would be a better fit.
9. If a report fails to meet a user's need, but the user cannot articulate the
required changes, what is the BID's best course of action?
a) Assume the report is correct and close the ticket.
b) Delete the report and start over from scratch.
c) Ask for a written list of data points, disregarding the user's workflow.
d) Re-analyze the request with the user, focusing on the purpose and required
actions.
Correct Answer: d) Re-analyze the request with the user, focusing on the purpose
and required actions.
Rationale: When communication breaks down, the BID should return to the initial
analysis phase. By refocusing on the report's purpose and how the user will act on
its output, the BID can often clarify requirements more effectively than by
focusing on technical specifications.
10. Your Epic application coordinator asks you for a list of all patients currently
admitted to the hospital. They need to use this list in their daily huddle to discuss
patient flow. What type of report is this?
a) Analytical
b) Clinical
c) Operational
d) Historical
Correct Answer: c) Operational
Rationale: This request is for a current-state list used for an immediate, daily task.
It is time-sensitive and actionable, fitting the definition of an operational report.
11. Which of the following is a core characteristic of operational reports?
a) They show data over an extended time.
b) They are often used for regulatory reporting.
4|Page
