CLR110 Clarity Data Model Latest 2026
UPDATED Exam Questions and Verified
Answers (2026/2027) | Graded A+ |
100% Success
What EPIC tools can get more information about Clarity database objects in
hyperspace? - Correct Answer -Clarity Dictionary& Report Repository
Contact Serial Number - Correct Answer -A Contact Serial Number, or CSN, is a
serial number that is unique for all contacts within that master file.
Contact Date Real - Correct Answer -A Contact Date Real, or CDR, is a date in Epic's
internal format, followed by two decimal places that start at .00 and increment for
each additional contact on the same date.
Cardinality - Correct Answer -It describes the numerical relationship between
entities in two tables.
,Networked Item - Correct Answer -Networked items in Chronicles define
relationships between an item in one master file and a record or contact. Each
networked item will store the ID of a Chronicles record or contact.
How do you Identify the granularity of a table based on the primary key
documented in the Clarity Compass or Clarity Dictionary? - Correct Answer -
Identify the add and response type
-Add Types
>> No-Add: +ID
>> Overtime +ID + CSN/CDR
-Response Types
>> Single: NA
>>Multiple: + Line
1 row per record, 1 row per line per record, 1 row per contact, 1 row per line per
contact
How do you Identify the cardinality of a join based on primary keys in Clarity? -
Correct Answer -Starting the join with the most granular table will maintain
consistent granularity with each subsequent join. However, this may not always
meet the needs of your report. For example, the join type could change the result
set, but only in the one-to-zero-or-.. direction.
,How do you Determine foreign keys between Clarity tables that extract from the
same master file? - Correct Answer -See the many-to-one diagram under "Linking
diagrams"
How do you Use Epic tools to identify networked items? - Correct Answer -Each
networked item will store the ID of a Chronicles record or contact. the (.1 or
CSN/CDR)
How do you Use Chronicles networked items to determine Clarity foreign keys -
Correct Answer -Use the Clarity Compass (column search) to look up the
corresponding tables and columns in Clarity.
The relationship between Chronicles master files and extracted tables in Clarity -
Correct Answer -Join the primary key to the networked item
When to use an INNER JOIN vs a LEFT OUTER JOIN in Clarity - Correct Answer -The
reporting need, load type and frequency will determine whether two tables
should be joined using a left outer join or an inner join.
, Why is research started in Chronicles? - Correct Answer -- Understanding how the
data is structured in Chronicles will allow you to better understand the structure
of Clarity
- Researching the record in the Record viewer will allow you to validate the data in
the source and explore link between data points
- You cannot trust the naming conventions in Clarity
Why doesn't one Chronicles master file translate into one Clarity table? - Correct
Answer -Clarity was built to easily store and retrieve small amounts of information
across many topics at once.
two main principles for constructing tables in the Clarity database: - Correct
Answer -Minimize redundant data
Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a single
record? - Correct Answer -Add type and response type
Add Type - Correct Answer -Indicates if data is stored on a record or on a contact
in the record.
Categorized as either No-Add or Overtime (Response Each Time or Lookback)
No-Add: stored on the record. Always considered "current".
UPDATED Exam Questions and Verified
Answers (2026/2027) | Graded A+ |
100% Success
What EPIC tools can get more information about Clarity database objects in
hyperspace? - Correct Answer -Clarity Dictionary& Report Repository
Contact Serial Number - Correct Answer -A Contact Serial Number, or CSN, is a
serial number that is unique for all contacts within that master file.
Contact Date Real - Correct Answer -A Contact Date Real, or CDR, is a date in Epic's
internal format, followed by two decimal places that start at .00 and increment for
each additional contact on the same date.
Cardinality - Correct Answer -It describes the numerical relationship between
entities in two tables.
,Networked Item - Correct Answer -Networked items in Chronicles define
relationships between an item in one master file and a record or contact. Each
networked item will store the ID of a Chronicles record or contact.
How do you Identify the granularity of a table based on the primary key
documented in the Clarity Compass or Clarity Dictionary? - Correct Answer -
Identify the add and response type
-Add Types
>> No-Add: +ID
>> Overtime +ID + CSN/CDR
-Response Types
>> Single: NA
>>Multiple: + Line
1 row per record, 1 row per line per record, 1 row per contact, 1 row per line per
contact
How do you Identify the cardinality of a join based on primary keys in Clarity? -
Correct Answer -Starting the join with the most granular table will maintain
consistent granularity with each subsequent join. However, this may not always
meet the needs of your report. For example, the join type could change the result
set, but only in the one-to-zero-or-.. direction.
,How do you Determine foreign keys between Clarity tables that extract from the
same master file? - Correct Answer -See the many-to-one diagram under "Linking
diagrams"
How do you Use Epic tools to identify networked items? - Correct Answer -Each
networked item will store the ID of a Chronicles record or contact. the (.1 or
CSN/CDR)
How do you Use Chronicles networked items to determine Clarity foreign keys -
Correct Answer -Use the Clarity Compass (column search) to look up the
corresponding tables and columns in Clarity.
The relationship between Chronicles master files and extracted tables in Clarity -
Correct Answer -Join the primary key to the networked item
When to use an INNER JOIN vs a LEFT OUTER JOIN in Clarity - Correct Answer -The
reporting need, load type and frequency will determine whether two tables
should be joined using a left outer join or an inner join.
, Why is research started in Chronicles? - Correct Answer -- Understanding how the
data is structured in Chronicles will allow you to better understand the structure
of Clarity
- Researching the record in the Record viewer will allow you to validate the data in
the source and explore link between data points
- You cannot trust the naming conventions in Clarity
Why doesn't one Chronicles master file translate into one Clarity table? - Correct
Answer -Clarity was built to easily store and retrieve small amounts of information
across many topics at once.
two main principles for constructing tables in the Clarity database: - Correct
Answer -Minimize redundant data
Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a single
record? - Correct Answer -Add type and response type
Add Type - Correct Answer -Indicates if data is stored on a record or on a contact
in the record.
Categorized as either No-Add or Overtime (Response Each Time or Lookback)
No-Add: stored on the record. Always considered "current".
