CLR110 CLARITY DATA MODEL EXAM SCRIPT
2026 TEST PAPER QUESTIONS AND
SOLUTIONS GRADED A+
◉ Item Information Window ﴾Ctrl + Click Method﴿. Answer: The
window can be accessed when
a Hyperspace user knows the exact field within a workflow that stores
the data they want on a report. When you control‐left click on a data
entry field in Hyperspace, the Item Information window appears.
This window shows the INI and item number in which this data is
stored, along with other information
about the item as a whole. 2-6
◉ Record Viewer. Answer: The Record Viewer is an activity in
Hyperspace that provides a read‐only view of raw data in Chronicles
record. 2-8
◉ Contact Serial Number (CSN). Answer: A Contact Serial Number or
CSN will uniquely identify a contact within a master file. 2-9
◉ CTRL + F. Answer: This will bring up a search bar. The search bar
will search through item
,names as well as values stored.2-10
◉ Further Item Filtering >
Text Search. Answer: This will filter the items shown to only include
items that store the value
you searched for. 2-10
◉ Null Values in Clarity. Answer: Any Clarity columns that is not a
primary key can contain null values. Even foreign keys may be null.
Null values exist for several reasons: Not all fields are populated in
Chronicles ETL data cleansing deletes incorrectly formatted data A
column may no longer extract data because it is deprecated. 2-11
◉ Item Editor. Answer: The Item Editor shows the definitions of a
Chronicles item. 2-11
◉ Category List. Answer: When using a category list value as a filter,
the query can run more efficiently when filtering on the
category value itself rather than the name in the category list table. To
find name to display for a
particular value, you need to see the category list. 2-12
◉ Add Type. Answer: An item's Add Type describes how long a piece of
data is valid. It determines whether an item's value is
, stored on each contact, or directly to the record. 2-17
◉ No-Add. Answer: No‐Add items store data directly on a record, not a
specific contact. The
value of a no‐add item should be considered true for all contacts on that
record. 2-18
◉ Response Each Time. Answer: Response each time items store values
separately on each of a record's contacts. If a response each time item is
blank for a certain contact, it should be considered unknown. 2-18
◉ Lookback. Answer: Lookback items store values separately on each
contact, but assume that the last value entered remains true until a new
value is entered. 2-18
◉ Response Type. Answer: An item's Response Type determines how
many lines of data an item can hold. 2-18
◉ Single Response. Answer: Only one line of data can be stored per
contact. 2-19
◉ Multiple Response. Answer: Multiple lines of data can be stored per
contact.
2026 TEST PAPER QUESTIONS AND
SOLUTIONS GRADED A+
◉ Item Information Window ﴾Ctrl + Click Method﴿. Answer: The
window can be accessed when
a Hyperspace user knows the exact field within a workflow that stores
the data they want on a report. When you control‐left click on a data
entry field in Hyperspace, the Item Information window appears.
This window shows the INI and item number in which this data is
stored, along with other information
about the item as a whole. 2-6
◉ Record Viewer. Answer: The Record Viewer is an activity in
Hyperspace that provides a read‐only view of raw data in Chronicles
record. 2-8
◉ Contact Serial Number (CSN). Answer: A Contact Serial Number or
CSN will uniquely identify a contact within a master file. 2-9
◉ CTRL + F. Answer: This will bring up a search bar. The search bar
will search through item
,names as well as values stored.2-10
◉ Further Item Filtering >
Text Search. Answer: This will filter the items shown to only include
items that store the value
you searched for. 2-10
◉ Null Values in Clarity. Answer: Any Clarity columns that is not a
primary key can contain null values. Even foreign keys may be null.
Null values exist for several reasons: Not all fields are populated in
Chronicles ETL data cleansing deletes incorrectly formatted data A
column may no longer extract data because it is deprecated. 2-11
◉ Item Editor. Answer: The Item Editor shows the definitions of a
Chronicles item. 2-11
◉ Category List. Answer: When using a category list value as a filter,
the query can run more efficiently when filtering on the
category value itself rather than the name in the category list table. To
find name to display for a
particular value, you need to see the category list. 2-12
◉ Add Type. Answer: An item's Add Type describes how long a piece of
data is valid. It determines whether an item's value is
, stored on each contact, or directly to the record. 2-17
◉ No-Add. Answer: No‐Add items store data directly on a record, not a
specific contact. The
value of a no‐add item should be considered true for all contacts on that
record. 2-18
◉ Response Each Time. Answer: Response each time items store values
separately on each of a record's contacts. If a response each time item is
blank for a certain contact, it should be considered unknown. 2-18
◉ Lookback. Answer: Lookback items store values separately on each
contact, but assume that the last value entered remains true until a new
value is entered. 2-18
◉ Response Type. Answer: An item's Response Type determines how
many lines of data an item can hold. 2-18
◉ Single Response. Answer: Only one line of data can be stored per
contact. 2-19
◉ Multiple Response. Answer: Multiple lines of data can be stored per
contact.
