CLR110 Clarity Data Model Exam Key Exam Topics & Coverage:
Chronicles to Clarity Mapping: Identifying
data elements in Chronicles and locating
them in Clarity, specifically using INI and
item numbers.
Data Storage & Types: Understanding how
data is stored, including No-Add (record-
level), Overtime (contact-level), Multiple
Response, and Category items.
Clarity Compass: Using the Compass tool to
find tables and columns for reporting.
Database Objects: Distinguishing between
different types of database objects in
Clarity.
Reporting Tools: Choosing the correct
reporting tool (e.g., Crystal Reports,
,Reporting Workbench) based on user
needs, such as operational (real-time) vs.
analytical (historical) reports.
ETL (Extract, Transform, Load): Basic
understanding of how data moves from
Chronicles to Clarity.
Joins and Relationships: Understanding how
to join tables and recognize primary/foreign
keys.
,A Chronicles item can store one 1. B, C and F. If a Chronicles item can store
or more options from a limited one or more options it is a multiple
list. Which of the following response item. If the options come from a
could account for this behavior? limited list, that item may be a category
(Choose all that apply) item, where the category list is the list of
A. Single Response options, or networked, where the records or
B. Multiple Response contacts in the destination master file is the
C. Networked list of options
D. Overtime
E. No-Add
F. Category
0. Identify the data elements you will need
What are the steps to writing a for the report.
report request? 1. Find the INI + Item numbers of the data
points to use on the report
2. Use the INI + Item numbers to find the
appropriate Clarity tables and columns.
, 3. Join the Clarity tables together using the
correct foreign key information
What activities in Chronicles can - Item Information Window (Ctrl + click)
be used to look up information - Record Viewer
about data? - Item Editor
- Category List Maintenance
When will Ctrl + click not work? If the field is read-only or simply
incompatible
What does the Record Viewer The Record Viewer provides a read-only
show? view of raw data in a Chronicles record.
Chronicles to Clarity Mapping: Identifying
data elements in Chronicles and locating
them in Clarity, specifically using INI and
item numbers.
Data Storage & Types: Understanding how
data is stored, including No-Add (record-
level), Overtime (contact-level), Multiple
Response, and Category items.
Clarity Compass: Using the Compass tool to
find tables and columns for reporting.
Database Objects: Distinguishing between
different types of database objects in
Clarity.
Reporting Tools: Choosing the correct
reporting tool (e.g., Crystal Reports,
,Reporting Workbench) based on user
needs, such as operational (real-time) vs.
analytical (historical) reports.
ETL (Extract, Transform, Load): Basic
understanding of how data moves from
Chronicles to Clarity.
Joins and Relationships: Understanding how
to join tables and recognize primary/foreign
keys.
,A Chronicles item can store one 1. B, C and F. If a Chronicles item can store
or more options from a limited one or more options it is a multiple
list. Which of the following response item. If the options come from a
could account for this behavior? limited list, that item may be a category
(Choose all that apply) item, where the category list is the list of
A. Single Response options, or networked, where the records or
B. Multiple Response contacts in the destination master file is the
C. Networked list of options
D. Overtime
E. No-Add
F. Category
0. Identify the data elements you will need
What are the steps to writing a for the report.
report request? 1. Find the INI + Item numbers of the data
points to use on the report
2. Use the INI + Item numbers to find the
appropriate Clarity tables and columns.
, 3. Join the Clarity tables together using the
correct foreign key information
What activities in Chronicles can - Item Information Window (Ctrl + click)
be used to look up information - Record Viewer
about data? - Item Editor
- Category List Maintenance
When will Ctrl + click not work? If the field is read-only or simply
incompatible
What does the Record Viewer The Record Viewer provides a read-only
show? view of raw data in a Chronicles record.
