CLR110 CLARITY DATA MODEL EXAM QUESTIONS AND ANSWERS (VERIFIED
ANSWERS) UPDATED (ACTUAL EXAM) 2025\2026 LATEST VERSION!!
Question 1
What does "Load Frequency" determine in a Clarity table?
A) The speed at which a SQL query runs
B) How often the data is extracted from Chronicles to Clarity
C) The number of users who can access the table
D) The maximum number of rows a table can hold
E) The programming language used to create the table
Correct Answer: B) How often the data is extracted from Chronicles to Clarity
Rationale: Load frequency defines the schedule for the ETL (Extract, Transform, Load)
process. While most tables are updated nightly, others may be configured for weekly or
monthly updates depending on organizational needs and performance.
Question 2
What is the standard interval for an "Incremental" load in the Clarity system?
A) Every hour
B) Every 12 hours
C) Every 24 hours (nightly)
D) Once a week
E) Once a month
Correct Answer: C) Every 24 hours (nightly)
Rationale: Incremental loads typically take place nightly. This ensures that the Clarity
reporting database reflects the production data from the previous day without bogging
down the production server during peak clinical hours.
Question 3
When a new version of Epic software is released, what is the primary reason for "retiring" certain
items?
A) To make the database larger
B) To force users to buy new hardware
C) To replace old items with new items that are more efficient or have desired behaviors
D) To delete all patient records from the previous year
E) To change the color of the Hyperspace background
Correct Answer: C) To replace old items with new items that are more efficient or have
desired behaviors
Rationale: Software upgrades often involve schema changes where old methods of storing
data are replaced by improved structures. Retired items are maintained for historical data
but are no longer used for new documentation.
Question 4
Which of the following is the most common reason a column in a Clarity table becomes
"Deprecated"?
, 2
A) The server ran out of disk space.
B) The data is too confidential to report on.
C) There was a change in the underlying Chronicles data or a better reporting structure is now
available.
D) The SQL developer deleted the column by mistake.
E) The patient requested the data be removed.
Correct Answer: C) There was a change in the underlying Chronicles data or a better
reporting structure is now available.
Rationale: Deprecation signals to report writers that they should transition to a newer, more
accurate, or more efficient column/table. Deprecated columns usually stop receiving new
data once the transition period is over.
Question 5
What occurs when a column is officially marked as "Deprecated" in the Clarity Compass?
A) All existing data in that column is deleted.
B) The table it belongs to is removed from the database.
C) No more data will be extracted into that column during future ETL runs.
D) The column name is changed to "DO_NOT_USE."
E) The ETL administrator must manually enter data into it.
Correct Answer: C) No more data will be extracted into that column during future ETL
runs.
Rationale: Deprecation means the column is no longer supported for new data. While
historical data remains, any new activity in Chronicles will not flow into a deprecated
column, potentially leading to "empty" results for recent dates.
Question 6
Which tool is used to compare new E records (after an upgrade) to existing C records to identify
new and changed tables?
A) SQL Profiler
B) Chronicles Record Viewer
C) Compass Comparison
D) Analytics Catalog
E) Report Repository
Correct Answer: C) Compass Comparison
Rationale: The Compass Comparison tool is essential during upgrades. It allows ETL
administrators and analysts to see exactly which tables and columns have been added,
changed, or deprecated between versions.
Question 7
If you find a table definition in the Clarity Compass, does it guarantee that the table exists on
your local Clarity database?
, 3
A) Yes, all Compass tables are automatically created.
B) No, the Compass shows all possible tables, but organizations may choose not to extract every
one.
C) Yes, but only if the table is marked as "Weekly."
D) No, only tables with patient names are extracted.
E) Only if you have a C-record for that table.
Correct Answer: B) No, the Compass shows all possible tables, but organizations may choose
not to extract every one.
Rationale: The Clarity Compass is a "dictionary" of what is possible. Organizations often
disable tables they do not need to save on storage and processing time. You must verify if
the table is actually being extracted at your site.
Question 8
Which of the following methods can be used to verify if a specific table exists on your
organization's Clarity database?
A) Looking at a patient's chart in Hyperspace
B) Querying the table in SQL or looking for "C" records in the Clarity Compass
C) Asking a doctor if they use that table
D) Checking the hardware serial number of the server
E) Reading the Epic UserWeb forums
Correct Answer: B) Querying the table in SQL or looking for "C" records in the Clarity
Compass
Rationale: C-records represent the specific "copies" of definitions that the ETL console is
currently using to move data. If there is no C-record, the table is not being extracted.
Question 9
In the Analytics Catalog, what prefix is used to filter for Clarity-specific objects?
A) CB
B) CR
C) CL
D) XL
E) SQL
Correct Answer: C) CL
Rationale: The Analytics Catalog combines Caboodle and Clarity metadata. Using the
"CL" prefix filters specifically for Clarity tables and columns.
Question 10
In the Analytics Catalog, what prefix is used to filter for Caboodle-specific objects?
A) CL
B) CB
C) CC
, 4
D) CD
E) DW
Correct Answer: B) CB
Rationale: "CB" stands for Caboodle, which is Epic's dimensional data warehouse. This
distinction helps analysts ensure they are looking at the correct data source.
Question 11
Which filter in the Analytics Catalog should be used to limit results specifically to database
objects in Clarity or Caboodle?
A) Report Repository Filter
B) User Settings Filter
C) Data Dictionary Filter
D) ETL Status Filter
E) Metadata Search
Correct Answer: C) Data Dictionary Filter
Rationale: The Data Dictionary filter specifically narrows the Analytics Catalog results to
the structural components (tables and columns) of the databases.
Question 12
If you want to know which other database objects depend on a specific Clarity table, which
section of the Analytics Catalog dictionary should you consult?
A) The Summary section
B) The Dependencies section
C) The Item Number section
D) The Security section
E) The Load Log section
Correct Answer: B) The Dependencies section
Rationale: The Dependencies section is critical for impact analysis. It shows which views,
reports, or other tables rely on the object you are investigating, helping you avoid breaking
reports when changes occur.
Question 13
How many "E records" exist in the Epic system?
A) Only one for the entire system
B) One for each patient in the database
C) One for every database object possible in Clarity
D) Ten for every master file
E) None; Clarity uses C records only
Correct Answer: C) One for every database object possible in Clarity
Rationale: E records (stored in the E0B master file) are the baseline templates provided by
Epic for every table and column that could potentially be extracted into Clarity.
ANSWERS) UPDATED (ACTUAL EXAM) 2025\2026 LATEST VERSION!!
Question 1
What does "Load Frequency" determine in a Clarity table?
A) The speed at which a SQL query runs
B) How often the data is extracted from Chronicles to Clarity
C) The number of users who can access the table
D) The maximum number of rows a table can hold
E) The programming language used to create the table
Correct Answer: B) How often the data is extracted from Chronicles to Clarity
Rationale: Load frequency defines the schedule for the ETL (Extract, Transform, Load)
process. While most tables are updated nightly, others may be configured for weekly or
monthly updates depending on organizational needs and performance.
Question 2
What is the standard interval for an "Incremental" load in the Clarity system?
A) Every hour
B) Every 12 hours
C) Every 24 hours (nightly)
D) Once a week
E) Once a month
Correct Answer: C) Every 24 hours (nightly)
Rationale: Incremental loads typically take place nightly. This ensures that the Clarity
reporting database reflects the production data from the previous day without bogging
down the production server during peak clinical hours.
Question 3
When a new version of Epic software is released, what is the primary reason for "retiring" certain
items?
A) To make the database larger
B) To force users to buy new hardware
C) To replace old items with new items that are more efficient or have desired behaviors
D) To delete all patient records from the previous year
E) To change the color of the Hyperspace background
Correct Answer: C) To replace old items with new items that are more efficient or have
desired behaviors
Rationale: Software upgrades often involve schema changes where old methods of storing
data are replaced by improved structures. Retired items are maintained for historical data
but are no longer used for new documentation.
Question 4
Which of the following is the most common reason a column in a Clarity table becomes
"Deprecated"?
, 2
A) The server ran out of disk space.
B) The data is too confidential to report on.
C) There was a change in the underlying Chronicles data or a better reporting structure is now
available.
D) The SQL developer deleted the column by mistake.
E) The patient requested the data be removed.
Correct Answer: C) There was a change in the underlying Chronicles data or a better
reporting structure is now available.
Rationale: Deprecation signals to report writers that they should transition to a newer, more
accurate, or more efficient column/table. Deprecated columns usually stop receiving new
data once the transition period is over.
Question 5
What occurs when a column is officially marked as "Deprecated" in the Clarity Compass?
A) All existing data in that column is deleted.
B) The table it belongs to is removed from the database.
C) No more data will be extracted into that column during future ETL runs.
D) The column name is changed to "DO_NOT_USE."
E) The ETL administrator must manually enter data into it.
Correct Answer: C) No more data will be extracted into that column during future ETL
runs.
Rationale: Deprecation means the column is no longer supported for new data. While
historical data remains, any new activity in Chronicles will not flow into a deprecated
column, potentially leading to "empty" results for recent dates.
Question 6
Which tool is used to compare new E records (after an upgrade) to existing C records to identify
new and changed tables?
A) SQL Profiler
B) Chronicles Record Viewer
C) Compass Comparison
D) Analytics Catalog
E) Report Repository
Correct Answer: C) Compass Comparison
Rationale: The Compass Comparison tool is essential during upgrades. It allows ETL
administrators and analysts to see exactly which tables and columns have been added,
changed, or deprecated between versions.
Question 7
If you find a table definition in the Clarity Compass, does it guarantee that the table exists on
your local Clarity database?
, 3
A) Yes, all Compass tables are automatically created.
B) No, the Compass shows all possible tables, but organizations may choose not to extract every
one.
C) Yes, but only if the table is marked as "Weekly."
D) No, only tables with patient names are extracted.
E) Only if you have a C-record for that table.
Correct Answer: B) No, the Compass shows all possible tables, but organizations may choose
not to extract every one.
Rationale: The Clarity Compass is a "dictionary" of what is possible. Organizations often
disable tables they do not need to save on storage and processing time. You must verify if
the table is actually being extracted at your site.
Question 8
Which of the following methods can be used to verify if a specific table exists on your
organization's Clarity database?
A) Looking at a patient's chart in Hyperspace
B) Querying the table in SQL or looking for "C" records in the Clarity Compass
C) Asking a doctor if they use that table
D) Checking the hardware serial number of the server
E) Reading the Epic UserWeb forums
Correct Answer: B) Querying the table in SQL or looking for "C" records in the Clarity
Compass
Rationale: C-records represent the specific "copies" of definitions that the ETL console is
currently using to move data. If there is no C-record, the table is not being extracted.
Question 9
In the Analytics Catalog, what prefix is used to filter for Clarity-specific objects?
A) CB
B) CR
C) CL
D) XL
E) SQL
Correct Answer: C) CL
Rationale: The Analytics Catalog combines Caboodle and Clarity metadata. Using the
"CL" prefix filters specifically for Clarity tables and columns.
Question 10
In the Analytics Catalog, what prefix is used to filter for Caboodle-specific objects?
A) CL
B) CB
C) CC
, 4
D) CD
E) DW
Correct Answer: B) CB
Rationale: "CB" stands for Caboodle, which is Epic's dimensional data warehouse. This
distinction helps analysts ensure they are looking at the correct data source.
Question 11
Which filter in the Analytics Catalog should be used to limit results specifically to database
objects in Clarity or Caboodle?
A) Report Repository Filter
B) User Settings Filter
C) Data Dictionary Filter
D) ETL Status Filter
E) Metadata Search
Correct Answer: C) Data Dictionary Filter
Rationale: The Data Dictionary filter specifically narrows the Analytics Catalog results to
the structural components (tables and columns) of the databases.
Question 12
If you want to know which other database objects depend on a specific Clarity table, which
section of the Analytics Catalog dictionary should you consult?
A) The Summary section
B) The Dependencies section
C) The Item Number section
D) The Security section
E) The Load Log section
Correct Answer: B) The Dependencies section
Rationale: The Dependencies section is critical for impact analysis. It shows which views,
reports, or other tables rely on the object you are investigating, helping you avoid breaking
reports when changes occur.
Question 13
How many "E records" exist in the Epic system?
A) Only one for the entire system
B) One for each patient in the database
C) One for every database object possible in Clarity
D) Ten for every master file
E) None; Clarity uses C records only
Correct Answer: C) One for every database object possible in Clarity
Rationale: E records (stored in the E0B master file) are the baseline templates provided by
Epic for every table and column that could potentially be extracted into Clarity.
