CLR 110 - Clarity Data Model Fundamentals
Exam Questions and Correct Answers
Question 1
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 .
Answer>>
networking
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
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
Answer>>
Clarity Compass
Page 1 of 99
,Question 4
Epic's applications all access the same database in real-
time
Answer>>
Chronicles
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:
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.
Answer>>
Page 2 of 99
,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
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
Answer>>
Compass Table Summary
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
Answer>>
weight
Question 10
If you see two columns in one table that otherwise appear to
be identical, make sure to read the column
Answer>>
Page 3 of 99
, descriptions
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.
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.
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.
Question 13
Why should you not use Clarity for operational reporting
needs?
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
Page 4 of 99
Exam Questions and Correct Answers
Question 1
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 .
Answer>>
networking
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
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
Answer>>
Clarity Compass
Page 1 of 99
,Question 4
Epic's applications all access the same database in real-
time
Answer>>
Chronicles
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:
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.
Answer>>
Page 2 of 99
,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
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
Answer>>
Compass Table Summary
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
Answer>>
weight
Question 10
If you see two columns in one table that otherwise appear to
be identical, make sure to read the column
Answer>>
Page 3 of 99
, descriptions
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.
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.
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.
Question 13
Why should you not use Clarity for operational reporting
needs?
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
Page 4 of 99
