CLR110 EXAM QUESTIONS AND
ANSWERS (GRADED A)
How to get to Item Information Window? - ANSWER-CTRL click any editable data entry
field in Hyperspace
What does the Item Information Window contain? - ANSWER-INI and item number,
clarity table and column, help text, additional details that links to the Item Editor
Limitations of CTRL click - ANSWER-Doesn't work for all data points. Often doesn't
work for read only fields
List methods for conducting Chronicles research - ANSWER-Item Information Window,
Record Viewer, Item Editor, Category List Maintenance
Record viewer input needs - ANSWER-Master file, record, contact
Record viewer output - ANSWER-INI and item number
How is data displayed different in Chronicles vs Clarity for a category list? - ANSWER-
Chronicles has category value and name, Clarity only has category value
How is the data extraction different in Caboodle vs Clarity when there is no value
entered in chronicles? - ANSWER-Caboodle would have -1 or -2, Clarity would just
have Null
True or false: primary and foreign keys can be null in Clarity - ANSWER-False. Foreign
keys can be null but primary cannot
What is the unique identifier for a record? - ANSWER-Record ID
What is the unique identifier for a line? - ANSWER-Line number
True or false: every master file contains CSNs - ANSWER-False, only some
What level is a CDR unique on? - ANSWER-Record level. So we also need Record ID
to uniquely identify the contact
True or false: views and derived tables are results saved at ETL - ANSWER-False. That
is only true for derived tables, views just store the query
Item editor shows - ANSWER-Definitions and properties of a chronicles item. Doesn't
show a particular value
, Category list in item editor displays how many values? - ANSWER-100
Category list maintenance - ANSWER-Displays all values not just first 100
Release range - ANSWER-Either all customer owned or all categories. For if customer
sets category values or if epic does
No add type - ANSWER-Stores data directly on a record and is true for all contacts on
that record
Response each time - ANSWER-Stores values separately on each contact
Look back - ANSWER-Stores values separately but last value is true until a new value
is entered
Overtime Add Types - ANSWER-Response each time and look back
List the different response types - ANSWER-Single, multiple, related
Which two tools are used to find Clarity columns? - ANSWER-Clarity compass and
cogito data dictionary
Where do you access the clarity compass? - ANSWER-Column Search, Database
Object Search
What does the clarity compass do? - ANSWER-Sets definitions for how Chronicles
items will translate into Clarity
True or false: the relationship between Chronicles items and Clarity columns is one to
one - ANSWER-False. And item can be extracted to multiple columns and a column can
extract data from multiple items
In what cases would there be no chronicles info in the column search? - ANSWER-If the
columns extracts data not stored in a chronicles item or the columns extracts calculated
data
True or false: one chronicles master file translates into one clarity table - ANSWER-
False. They have different granularity
True or false: internal and external identifiers are unique - ANSWER-False. Only
internal must be unique
What are the two possible identifiers for contacts in Epic? - ANSWER-Contact serial
number (CSN) or contact date real (CDR) combined with record ID
ANSWERS (GRADED A)
How to get to Item Information Window? - ANSWER-CTRL click any editable data entry
field in Hyperspace
What does the Item Information Window contain? - ANSWER-INI and item number,
clarity table and column, help text, additional details that links to the Item Editor
Limitations of CTRL click - ANSWER-Doesn't work for all data points. Often doesn't
work for read only fields
List methods for conducting Chronicles research - ANSWER-Item Information Window,
Record Viewer, Item Editor, Category List Maintenance
Record viewer input needs - ANSWER-Master file, record, contact
Record viewer output - ANSWER-INI and item number
How is data displayed different in Chronicles vs Clarity for a category list? - ANSWER-
Chronicles has category value and name, Clarity only has category value
How is the data extraction different in Caboodle vs Clarity when there is no value
entered in chronicles? - ANSWER-Caboodle would have -1 or -2, Clarity would just
have Null
True or false: primary and foreign keys can be null in Clarity - ANSWER-False. Foreign
keys can be null but primary cannot
What is the unique identifier for a record? - ANSWER-Record ID
What is the unique identifier for a line? - ANSWER-Line number
True or false: every master file contains CSNs - ANSWER-False, only some
What level is a CDR unique on? - ANSWER-Record level. So we also need Record ID
to uniquely identify the contact
True or false: views and derived tables are results saved at ETL - ANSWER-False. That
is only true for derived tables, views just store the query
Item editor shows - ANSWER-Definitions and properties of a chronicles item. Doesn't
show a particular value
, Category list in item editor displays how many values? - ANSWER-100
Category list maintenance - ANSWER-Displays all values not just first 100
Release range - ANSWER-Either all customer owned or all categories. For if customer
sets category values or if epic does
No add type - ANSWER-Stores data directly on a record and is true for all contacts on
that record
Response each time - ANSWER-Stores values separately on each contact
Look back - ANSWER-Stores values separately but last value is true until a new value
is entered
Overtime Add Types - ANSWER-Response each time and look back
List the different response types - ANSWER-Single, multiple, related
Which two tools are used to find Clarity columns? - ANSWER-Clarity compass and
cogito data dictionary
Where do you access the clarity compass? - ANSWER-Column Search, Database
Object Search
What does the clarity compass do? - ANSWER-Sets definitions for how Chronicles
items will translate into Clarity
True or false: the relationship between Chronicles items and Clarity columns is one to
one - ANSWER-False. And item can be extracted to multiple columns and a column can
extract data from multiple items
In what cases would there be no chronicles info in the column search? - ANSWER-If the
columns extracts data not stored in a chronicles item or the columns extracts calculated
data
True or false: one chronicles master file translates into one clarity table - ANSWER-
False. They have different granularity
True or false: internal and external identifiers are unique - ANSWER-False. Only
internal must be unique
What are the two possible identifiers for contacts in Epic? - ANSWER-Contact serial
number (CSN) or contact date real (CDR) combined with record ID
