1|Page
CLR110 Clarity Data Model Fundamentals Course
Exam 2026 | Verified Questions and Detailed
Answers
OVERVIEW DESCRIPTION:
This document is designed for the CLR110 Clarity Data Model Fundamentals course. It covers
how data moves from Chronicles into Clarity, focusing on Add Type and Response Type to
understand table granularity and primary keys. It highlights essential research tools like
the Clarity Compass and Record Viewer, along with key concepts such as ETL processes,
cardinality, joins, and using AUDIT_ITM or ACCESS_LOG tables for audit and event tracking.
QUESTION 1
What value will be extracted to Caboodle for this item, and other networked items that
are not filled out in Chronicles?
CORRECT ANSWER:
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.
QUESTION 2
Why do null values exist in Clarity
CORRECT ANSWER:
Not all fields are populated in Chronicles
,2|Page
QUESTION 3
T/F columns that are non primary keys contain null values
CORRECT ANSWER:
True, even foreign key may be null.
QUESTION 4
What is a category list?
CORRECT ANSWER:
a list of defined values that can be stored in a Chronicles item
QUESTION 5
What is an add type
CORRECT ANSWER:
describes how long a piece of data is valid
QUESTION 6
response each time
CORRECT ANSWER:
considered true for all cases. if changed then old value is replaced example: SSN,
birthday
,3|Page
data stored separate on each contact record if blank then it is considered unknown
example: weight, blood pressure
QUESTION 7
lookback
CORRECT ANSWER:
store each item separately but if blank considers last value to be true Example: age,
address
QUESTION 8
No-Add
CORRECT ANSWER:
add type stored on record, not contact. considered true for all contacts
QUESTION 9
Response Each Time
CORRECT ANSWER:
Response type stored separately on each of the records contacts if blank, should be
considered unknown
, 4|Page
QUESTION 10
Response Type
CORRECT ANSWER:
add type stored separately on each contact assume that last value entered remains true
determines how many lines an item can hold at one time - Single Response - Multiple
Response - Related Group
QUESTION 11
Which of the following could account for this behavior? A Chronicles item stores a single
value, but can store a separate value for each contact on a record. Choose all that apply?
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No-Add
F. Category
CORRECT ANSWER:
A and D. If a Chronicles item can store only one value it is a single response item.
If a separate value is stored on each contact the add type is Overtime.
QUESTION 12
Which of the following could account for this behavior? A Chronicles item can store one
or more options from a limited list. Choose all that apply?
CLR110 Clarity Data Model Fundamentals Course
Exam 2026 | Verified Questions and Detailed
Answers
OVERVIEW DESCRIPTION:
This document is designed for the CLR110 Clarity Data Model Fundamentals course. It covers
how data moves from Chronicles into Clarity, focusing on Add Type and Response Type to
understand table granularity and primary keys. It highlights essential research tools like
the Clarity Compass and Record Viewer, along with key concepts such as ETL processes,
cardinality, joins, and using AUDIT_ITM or ACCESS_LOG tables for audit and event tracking.
QUESTION 1
What value will be extracted to Caboodle for this item, and other networked items that
are not filled out in Chronicles?
CORRECT ANSWER:
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.
QUESTION 2
Why do null values exist in Clarity
CORRECT ANSWER:
Not all fields are populated in Chronicles
,2|Page
QUESTION 3
T/F columns that are non primary keys contain null values
CORRECT ANSWER:
True, even foreign key may be null.
QUESTION 4
What is a category list?
CORRECT ANSWER:
a list of defined values that can be stored in a Chronicles item
QUESTION 5
What is an add type
CORRECT ANSWER:
describes how long a piece of data is valid
QUESTION 6
response each time
CORRECT ANSWER:
considered true for all cases. if changed then old value is replaced example: SSN,
birthday
,3|Page
data stored separate on each contact record if blank then it is considered unknown
example: weight, blood pressure
QUESTION 7
lookback
CORRECT ANSWER:
store each item separately but if blank considers last value to be true Example: age,
address
QUESTION 8
No-Add
CORRECT ANSWER:
add type stored on record, not contact. considered true for all contacts
QUESTION 9
Response Each Time
CORRECT ANSWER:
Response type stored separately on each of the records contacts if blank, should be
considered unknown
, 4|Page
QUESTION 10
Response Type
CORRECT ANSWER:
add type stored separately on each contact assume that last value entered remains true
determines how many lines an item can hold at one time - Single Response - Multiple
Response - Related Group
QUESTION 11
Which of the following could account for this behavior? A Chronicles item stores a single
value, but can store a separate value for each contact on a record. Choose all that apply?
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No-Add
F. Category
CORRECT ANSWER:
A and D. If a Chronicles item can store only one value it is a single response item.
If a separate value is stored on each contact the add type is Overtime.
QUESTION 12
Which of the following could account for this behavior? A Chronicles item can store one
or more options from a limited list. Choose all that apply?
