CLR 110 - Clarity Data Model Fundamentals
Exam Questions and Correct Answers
Question 1
Using ____-____ _____, a Crystal Report based off of Clarity data can be configured to
appear in the My Reports activity in Hyperspace right next to the Reporting
Workbench reports
Correct Answer
Epic-Crystal Integration
Question 2
Clarity Compass
You will generally see an empty grid in one of two cases - if the column extracts are
______ -______ data, or if the column extracts ______ data
Correct Answer
Non-Chronicles
Calculated
Question 3
This defines what Chronicles/production data will be extracted into which Clarity
tables and columns. Defines the structure of your Clarity tables, including primary
keys
Correct Answer
Clarity Compass
Question 4
Epic's applications all access the same _____ database in real-time
Correct Answer
Chronicles
Page 1 of 88
,Question 5
Take the following example of a report that should not be attempted using Clarity:
Currently admitted patients requiring a new IV within the next two hours. A user
should be able to jump from a patient shown on this report to the patient's chart.
If you tried to meet this reporting need with Clarity, you would quickly run into two
deal-breakers:
Correct Answer
Real-Time Data
Clarity extracts data from production on a daily, weekly, or even less-often basis.
Clarity data should always be assumed to be at least 24 hours out of date.
Clarity reports are often delivered via email or an external reporting portal. The
reports are not going to be as integrated into end-users' workflows as, for example,
Application Reports.
Question 6
____ _____ generally put more emphasis on filtering out unnecessary information than
they do on showing a comprehensive picture.
Correct Answer
Operational reports
Question 7
On a paper form, we'd be looking for a label Attending Provider somewhere. In Epic,
we're looking for what's called an ______
Correct Answer
item
Question 8
You can also find out which ZC_ table to link a _C column to using the Foreign Keys
listing in the ______ ______ ______
Correct Answer
Compass Table Summary
Page 2 of 88
,Question 9
Unfortunately, none of the results for a search correspond to Greg's weight. Since
looking for the exact value entered did not yield any results, we have to try something
else. Since items have names in addition to numbers, we can try searching by a
keyword. Enter "______" in the Find field
Correct Answer
weight
Question 10
What end users don't generally know is that none of these names are actually stored
in Paul's patient record. Instead, they are looked up as needed using a Chronicles
technique called ______ .
Correct Answer
networking
Question 11
Which Analytical report characteristic is described below...
Analytical reports are designed to make sense out of large patterns. To discern large
patterns, they need access to large amounts of data. An operational report might
display ten data points; an analytical report might display ten million.
Correct Answer
Comprehensive
Question 12
True or False. The best way to determine whether an inner join or a left outer join
should be used is the starting table's primary key.
Correct Answer
False. The reporting need, load type and frequency will determine whether two
tables should be joined using a left outer join or an inner join.
Page 3 of 88
, Question 13
Why should you not use Clarity for operational reporting needs?
Correct Answer
Most importantly, Clarity data is not real-time, so any operational reports built from
Clarity data will be out-of-date from the moment they're generated.
They also cannot be used interactively, such as in a workflow where the report
jumps a user to a patient's chart.
Question 14
A patient's date of birth is a ______ item, and you can assume that no matter how
many contacts the patient has, his date of birth is the same
Correct Answer
No-add
Question 15
Would the following report be an operational or analytical report?
Create a report that counts the number of logs each surgeon has been documented
as performing in during the past year. Display the log ID, the name of the surgeon,
and the log's primary procedure.
Correct Answer
Analytical report
Question 16
The system automatically enters a patient's age on each contact, but only if their age
is different from the last time the patient was seen is an example of which Add Type?
Correct Answer
Lookback
Page 4 of 88
Exam Questions and Correct Answers
Question 1
Using ____-____ _____, a Crystal Report based off of Clarity data can be configured to
appear in the My Reports activity in Hyperspace right next to the Reporting
Workbench reports
Correct Answer
Epic-Crystal Integration
Question 2
Clarity Compass
You will generally see an empty grid in one of two cases - if the column extracts are
______ -______ data, or if the column extracts ______ data
Correct Answer
Non-Chronicles
Calculated
Question 3
This defines what Chronicles/production data will be extracted into which Clarity
tables and columns. Defines the structure of your Clarity tables, including primary
keys
Correct Answer
Clarity Compass
Question 4
Epic's applications all access the same _____ database in real-time
Correct Answer
Chronicles
Page 1 of 88
,Question 5
Take the following example of a report that should not be attempted using Clarity:
Currently admitted patients requiring a new IV within the next two hours. A user
should be able to jump from a patient shown on this report to the patient's chart.
If you tried to meet this reporting need with Clarity, you would quickly run into two
deal-breakers:
Correct Answer
Real-Time Data
Clarity extracts data from production on a daily, weekly, or even less-often basis.
Clarity data should always be assumed to be at least 24 hours out of date.
Clarity reports are often delivered via email or an external reporting portal. The
reports are not going to be as integrated into end-users' workflows as, for example,
Application Reports.
Question 6
____ _____ generally put more emphasis on filtering out unnecessary information than
they do on showing a comprehensive picture.
Correct Answer
Operational reports
Question 7
On a paper form, we'd be looking for a label Attending Provider somewhere. In Epic,
we're looking for what's called an ______
Correct Answer
item
Question 8
You can also find out which ZC_ table to link a _C column to using the Foreign Keys
listing in the ______ ______ ______
Correct Answer
Compass Table Summary
Page 2 of 88
,Question 9
Unfortunately, none of the results for a search correspond to Greg's weight. Since
looking for the exact value entered did not yield any results, we have to try something
else. Since items have names in addition to numbers, we can try searching by a
keyword. Enter "______" in the Find field
Correct Answer
weight
Question 10
What end users don't generally know is that none of these names are actually stored
in Paul's patient record. Instead, they are looked up as needed using a Chronicles
technique called ______ .
Correct Answer
networking
Question 11
Which Analytical report characteristic is described below...
Analytical reports are designed to make sense out of large patterns. To discern large
patterns, they need access to large amounts of data. An operational report might
display ten data points; an analytical report might display ten million.
Correct Answer
Comprehensive
Question 12
True or False. The best way to determine whether an inner join or a left outer join
should be used is the starting table's primary key.
Correct Answer
False. The reporting need, load type and frequency will determine whether two
tables should be joined using a left outer join or an inner join.
Page 3 of 88
, Question 13
Why should you not use Clarity for operational reporting needs?
Correct Answer
Most importantly, Clarity data is not real-time, so any operational reports built from
Clarity data will be out-of-date from the moment they're generated.
They also cannot be used interactively, such as in a workflow where the report
jumps a user to a patient's chart.
Question 14
A patient's date of birth is a ______ item, and you can assume that no matter how
many contacts the patient has, his date of birth is the same
Correct Answer
No-add
Question 15
Would the following report be an operational or analytical report?
Create a report that counts the number of logs each surgeon has been documented
as performing in during the past year. Display the log ID, the name of the surgeon,
and the log's primary procedure.
Correct Answer
Analytical report
Question 16
The system automatically enters a patient's age on each contact, but only if their age
is different from the last time the patient was seen is an example of which Add Type?
Correct Answer
Lookback
Page 4 of 88
