CLR110 Clarity Data Model Fundamentals
Exam Questions Answered Correctly (157Qs)
2026 update
Compared to views, derived tables generally take less time to run because the data has been stored on
the DB - CORRECT ANSWERS True, views are saved queries, their use can affect performance.
Derived tables are stored procedures and thus perform better
Which tools can be used to learn more about Clarity tables and columns? - CORRECT ANSWERS
Analytics catalog
Database object search
Column search
Clarity Dictionary on the
A lab manager tells you he wants a report on lab specimens, and shows you the field where he can input
various information. What method would you use to find the INI + Item numbers of the data
he's looking for? - CORRECT ANSWERS Ctrl + Click
I IDM 130 is a networked item that is not filled in for this record. What value will be extracted to Clarity
for this item, and other Chronicles items that are not filled out? - CORRECT ANSWERS Null
What value will be extracted to Caboodle for this item, and other networked items that are not filled out
in Chronicles? - CORRECT ANSWERS if the column is a key column, Caboodle will have a ‐1
letting report writers know that this value was not populated in the source, while still enforcing
referential integrity.
T/F columns that are non primary keys contain null values - CORRECT ANSWERS True, even
foreign key may be null.
,Why do null values exist in Clarity - CORRECT ANSWERS Not all fields are populated in
Chronicles
ETL data cleansing deletes incorrectly formatted data
Data is deprecated y no longer extracted
!Appendix E: Record Viewer Tip Sheet contains more information on the filtering options available in the
record viewer - CORRECT ANSWERS
Item Editor - CORRECT ANSWERS Shows the definition of chronicle items.
Shows information about how the item behaves for all values
Hot Keys - CORRECT ANSWERS Opening Chart Search - Ctrl + Space
What is a category list? - CORRECT ANSWERS a list of defined values that can be stored in a
Chronicles item
Benefits and limitations of using category as a filter - CORRECT ANSWERS 1. more efficient
2. cannot only see first 100 values in item editor - must use category list maintenance to see complete
list
add types - CORRECT ANSWERS no add
response each time
lookback
what is an add type - CORRECT ANSWERS describes how long a piece of data is valid
no add - CORRECT ANSWERS considered true for all cases.
, if changed then old value is replaced
example: SSN, birthday
response each time - CORRECT ANSWERS data stored separate on each contact record
if blank then it is considered unknown
example: weight, blood pressure
lookback - CORRECT ANSWERS store each item separately but if blank considers last value to
be true
Example: age, address
No‐Add - CORRECT ANSWERS add type
stored on record, not contact.
considered true for all contacts
!Since both respond each time and lookback items store data on the contact, these add types are
referred to as overtime add types.
No‐Add data is stored at the record level Overtime data is stored at the contact level. - CORRECT
ANSWERS
Response Each Time - CORRECT ANSWERS Response type
stored separately on each of the records contacts
if blank, should be considered unknown
Lookback - CORRECT ANSWERS add type
stored separately on each contact
assume that last value entered remains true
Exam Questions Answered Correctly (157Qs)
2026 update
Compared to views, derived tables generally take less time to run because the data has been stored on
the DB - CORRECT ANSWERS True, views are saved queries, their use can affect performance.
Derived tables are stored procedures and thus perform better
Which tools can be used to learn more about Clarity tables and columns? - CORRECT ANSWERS
Analytics catalog
Database object search
Column search
Clarity Dictionary on the
A lab manager tells you he wants a report on lab specimens, and shows you the field where he can input
various information. What method would you use to find the INI + Item numbers of the data
he's looking for? - CORRECT ANSWERS Ctrl + Click
I IDM 130 is a networked item that is not filled in for this record. What value will be extracted to Clarity
for this item, and other Chronicles items that are not filled out? - CORRECT ANSWERS Null
What value will be extracted to Caboodle for this item, and other networked items that are not filled out
in Chronicles? - CORRECT ANSWERS if the column is a key column, Caboodle will have a ‐1
letting report writers know that this value was not populated in the source, while still enforcing
referential integrity.
T/F columns that are non primary keys contain null values - CORRECT ANSWERS True, even
foreign key may be null.
,Why do null values exist in Clarity - CORRECT ANSWERS Not all fields are populated in
Chronicles
ETL data cleansing deletes incorrectly formatted data
Data is deprecated y no longer extracted
!Appendix E: Record Viewer Tip Sheet contains more information on the filtering options available in the
record viewer - CORRECT ANSWERS
Item Editor - CORRECT ANSWERS Shows the definition of chronicle items.
Shows information about how the item behaves for all values
Hot Keys - CORRECT ANSWERS Opening Chart Search - Ctrl + Space
What is a category list? - CORRECT ANSWERS a list of defined values that can be stored in a
Chronicles item
Benefits and limitations of using category as a filter - CORRECT ANSWERS 1. more efficient
2. cannot only see first 100 values in item editor - must use category list maintenance to see complete
list
add types - CORRECT ANSWERS no add
response each time
lookback
what is an add type - CORRECT ANSWERS describes how long a piece of data is valid
no add - CORRECT ANSWERS considered true for all cases.
, if changed then old value is replaced
example: SSN, birthday
response each time - CORRECT ANSWERS data stored separate on each contact record
if blank then it is considered unknown
example: weight, blood pressure
lookback - CORRECT ANSWERS store each item separately but if blank considers last value to
be true
Example: age, address
No‐Add - CORRECT ANSWERS add type
stored on record, not contact.
considered true for all contacts
!Since both respond each time and lookback items store data on the contact, these add types are
referred to as overtime add types.
No‐Add data is stored at the record level Overtime data is stored at the contact level. - CORRECT
ANSWERS
Response Each Time - CORRECT ANSWERS Response type
stored separately on each of the records contacts
if blank, should be considered unknown
Lookback - CORRECT ANSWERS add type
stored separately on each contact
assume that last value entered remains true
