CLR 110 FINAL PAPER 2026 FULL
QUESTIONS AND CORRECT ANSWERS
ALREADY PASSED
◉ Database Object Search
Answer: Allows you to search for Clarity Tables by name and then
jump into the tables' Compass Table Summary
◉ Primary Key
Answer: A field or combination of fields that uniquely identify a
record
◉ Contact Date Real (CDR)
Answer: A contact date real is a date in Epic's internal format,
followed by a two decimal places that identify one contact among
many on the same date.
◉ Contact Serial Number (CSN)
Answer: A CSN is a number that uniquely identifies a single contact
within a master file
◉ Load Type - Full
, Answer: Truncates any data already in the Clarity table and re-
extracts the entire table from Chronicles
◉ Load Type - Incremental (REQ)
Answer: Finds data that has changed in Chronicles since the last
time the table was extracted, extracts the changes, and uses them to
update the table in Clarity
◉ Load Frequency
Answer: Default: Full-extract tables are weekly; Incremental tables
are daily (incremental)
◉ ETL
Answer: The Clarity Extract, Transform, and Load (ETL) process
extracts data from your Chronicles database, transforms Chronicles'
records, items, and contacts into the tables, rows, and columns of a
relational database, and loads it into an Oracle, Microsoft SQL Server,
or Teradata database on a dedicated reporting server.
◉ Category Tables
Answer: ZC_* tables; Performance Tip - filter or sort on the _C
columns
◉ Data Seeding
QUESTIONS AND CORRECT ANSWERS
ALREADY PASSED
◉ Database Object Search
Answer: Allows you to search for Clarity Tables by name and then
jump into the tables' Compass Table Summary
◉ Primary Key
Answer: A field or combination of fields that uniquely identify a
record
◉ Contact Date Real (CDR)
Answer: A contact date real is a date in Epic's internal format,
followed by a two decimal places that identify one contact among
many on the same date.
◉ Contact Serial Number (CSN)
Answer: A CSN is a number that uniquely identifies a single contact
within a master file
◉ Load Type - Full
, Answer: Truncates any data already in the Clarity table and re-
extracts the entire table from Chronicles
◉ Load Type - Incremental (REQ)
Answer: Finds data that has changed in Chronicles since the last
time the table was extracted, extracts the changes, and uses them to
update the table in Clarity
◉ Load Frequency
Answer: Default: Full-extract tables are weekly; Incremental tables
are daily (incremental)
◉ ETL
Answer: The Clarity Extract, Transform, and Load (ETL) process
extracts data from your Chronicles database, transforms Chronicles'
records, items, and contacts into the tables, rows, and columns of a
relational database, and loads it into an Oracle, Microsoft SQL Server,
or Teradata database on a dedicated reporting server.
◉ Category Tables
Answer: ZC_* tables; Performance Tip - filter or sort on the _C
columns
◉ Data Seeding
