Page 1 of 86
CLR 110 - Clarity Data Model Fundamentals Exam
ACTUAL EXAM COMPLETE QUESTIONS AND CORRECT
ANSWERS LATEST UPDATE THIS YEAR
Summarized Exam Coverage
The CLR 110 - Clarity Data Model Fundamentals course is designed for Business Intelligence Developers
(BIDs) who need to understand how data moves from Epic's Chronicles production database to the
Clarity reporting database . Key topics include:
Exam Domains :
• Report Development Process – Analyzing requests, determining reporting tool fit, distinguishing
operational vs. analytical reports
• Chronicles Data Storage – Master files, records, contacts, add types (No-Add, Response Each
Time, Lookback), response types (Single, Multiple, Related Group), category items, networked
items
• Clarity Data Extraction (ETL) – Extract, Transform, Load process; Clarity Compass; Clarity
Console; load frequencies (incremental, full); deprecation of columns
• Clarity Database Objects – Extracted tables, derived tables, views; primary keys; foreign keys;
category tables (ZC_ tables) and _C columns
• Reporting Tools – Application Reports, Reporting Workbench, Crystal Reports (Epic-Crystal
Integration), Clarity for analytical needs
• Epic Tools for Data Research – Ctrl+Click method, Record Viewer, Item Editor, Category List
Maintenance, Clarity Compass, Data Dictionary
Analytical reports show long-term trends and data over time, while operational reports are time-
sensitive, relatively small, easily accessible, and actionable . Clarity data should be assumed to be at
least 24 hours out of date, making it unsuitable for real-time operational needs .
1. What is the first step in the report writing process for a BID at Epic?
A) Open Crystal Reports and start designing
B) Analyze the request for key features including who needs it, what purpose, and how data should be
formatted
, Page 2 of 86
C) Extract data from Clarity immediately
D) Contact the end user for approval
Answer: B
The first step is analyzing the request to understand the audience, purpose, data volume, freshness
requirements, and output formatting needs .
2. A manager needs a real-time list of currently admitted patients requiring medication within the next
hour, with the ability to jump directly to patient charts. What reporting tool is appropriate?
A) Clarity with Crystal Reports
B) Reporting Workbench
C) An Application Report or Reporting Workbench with real-time data
D) Excel spreadsheet
Answer: C
*Clarity data is not real-time (at least 24 hours old), so this operational need requires an Application
Report or Reporting Workbench that accesses production data directly .*
3. A physician needs a report on surgical procedure volumes by surgeon over the past year. Should you
use Clarity?
, Page 3 of 86
A) No, Clarity cannot handle large data sets
B) Yes, Clarity is ideal for analytical reports over large data sets without slowing production servers
C) Only if the report runs daily
D) No, because surgical data is not in Clarity
Answer: B
Clarity is designed for analytical reporting over large data sets; running such reports in production would
impact end users .
4. Which of the following is NOT a key characteristic of operational reports?
A) Time-sensitive
B) Relatively small
C) Comprehensive and summarized
D) Easily accessible and actionable
Answer: C
Operational reports emphasize filtering out unnecessary information; comprehensiveness and
summarization are characteristics of analytical reports .
, Page 4 of 86
5. A user asks for a report that shows pending departmental transfers. This is an example of:
A) Analytical report
B) Operational report
C) Strategic report
D) Long-term trend report
Answer: B
Pending transfers are current, actionable, time-sensitive data needed for immediate workflow, not
historical trend analysis .
6. Why should you NOT use Clarity for operational reporting needs?
A) Clarity data is not real-time and reports cannot be integrated interactively into workflows
B) Clarity cannot handle large data sets
C) Clarity reports cannot be scheduled
D) Clarity only contains billing data
Answer: A
*Clarity data is extracted from production on a daily/weekly basis and is at least 24 hours old;
operational reports require real-time data .*
CLR 110 - Clarity Data Model Fundamentals Exam
ACTUAL EXAM COMPLETE QUESTIONS AND CORRECT
ANSWERS LATEST UPDATE THIS YEAR
Summarized Exam Coverage
The CLR 110 - Clarity Data Model Fundamentals course is designed for Business Intelligence Developers
(BIDs) who need to understand how data moves from Epic's Chronicles production database to the
Clarity reporting database . Key topics include:
Exam Domains :
• Report Development Process – Analyzing requests, determining reporting tool fit, distinguishing
operational vs. analytical reports
• Chronicles Data Storage – Master files, records, contacts, add types (No-Add, Response Each
Time, Lookback), response types (Single, Multiple, Related Group), category items, networked
items
• Clarity Data Extraction (ETL) – Extract, Transform, Load process; Clarity Compass; Clarity
Console; load frequencies (incremental, full); deprecation of columns
• Clarity Database Objects – Extracted tables, derived tables, views; primary keys; foreign keys;
category tables (ZC_ tables) and _C columns
• Reporting Tools – Application Reports, Reporting Workbench, Crystal Reports (Epic-Crystal
Integration), Clarity for analytical needs
• Epic Tools for Data Research – Ctrl+Click method, Record Viewer, Item Editor, Category List
Maintenance, Clarity Compass, Data Dictionary
Analytical reports show long-term trends and data over time, while operational reports are time-
sensitive, relatively small, easily accessible, and actionable . Clarity data should be assumed to be at
least 24 hours out of date, making it unsuitable for real-time operational needs .
1. What is the first step in the report writing process for a BID at Epic?
A) Open Crystal Reports and start designing
B) Analyze the request for key features including who needs it, what purpose, and how data should be
formatted
, Page 2 of 86
C) Extract data from Clarity immediately
D) Contact the end user for approval
Answer: B
The first step is analyzing the request to understand the audience, purpose, data volume, freshness
requirements, and output formatting needs .
2. A manager needs a real-time list of currently admitted patients requiring medication within the next
hour, with the ability to jump directly to patient charts. What reporting tool is appropriate?
A) Clarity with Crystal Reports
B) Reporting Workbench
C) An Application Report or Reporting Workbench with real-time data
D) Excel spreadsheet
Answer: C
*Clarity data is not real-time (at least 24 hours old), so this operational need requires an Application
Report or Reporting Workbench that accesses production data directly .*
3. A physician needs a report on surgical procedure volumes by surgeon over the past year. Should you
use Clarity?
, Page 3 of 86
A) No, Clarity cannot handle large data sets
B) Yes, Clarity is ideal for analytical reports over large data sets without slowing production servers
C) Only if the report runs daily
D) No, because surgical data is not in Clarity
Answer: B
Clarity is designed for analytical reporting over large data sets; running such reports in production would
impact end users .
4. Which of the following is NOT a key characteristic of operational reports?
A) Time-sensitive
B) Relatively small
C) Comprehensive and summarized
D) Easily accessible and actionable
Answer: C
Operational reports emphasize filtering out unnecessary information; comprehensiveness and
summarization are characteristics of analytical reports .
, Page 4 of 86
5. A user asks for a report that shows pending departmental transfers. This is an example of:
A) Analytical report
B) Operational report
C) Strategic report
D) Long-term trend report
Answer: B
Pending transfers are current, actionable, time-sensitive data needed for immediate workflow, not
historical trend analysis .
6. Why should you NOT use Clarity for operational reporting needs?
A) Clarity data is not real-time and reports cannot be integrated interactively into workflows
B) Clarity cannot handle large data sets
C) Clarity reports cannot be scheduled
D) Clarity only contains billing data
Answer: A
*Clarity data is extracted from production on a daily/weekly basis and is at least 24 hours old;
operational reports require real-time data .*
