CLR 110 - Clarity Data Model Fundamentals
Latest Update 2025-2026 Exam 190 Questions
with 100% Verified Correct Answers Guaranteed
A+
____ _____ generally put more emphasis on filtering out unnecessary information than
they do on showing a comprehensive picture. - CORRECT ANSWER: Operational
reports
____ _____ is a standardized operational reporting tool that can provide a similar look-
and-feel to reports across applications. - CORRECT ANSWER: Reporting Workbench
_____ is a tool that extracts data from your Chronicles production system, transforms it
into a relational format, and loads it onto a separate reporting server - CORRECT
ANSWER: Clarity
_____ is Epic's information center, a portal that hosts personalizable Home pages to
display Epic data, reports, and links to other pages. - CORRECT ANSWER: Radar
_____ is the programming language on which Chronicles is built - CORRECT
ANSWER: Caché Script
______ ______ ______ can help you identify tables related to a table you already know
- CORRECT ANSWER: Database Object Search
______ ______ ______ items store values separately on each of a record's contacts -
CORRECT ANSWER: Response each time
,______ ______ (which usually have names that start with "F_") are populated by scripts
on Clarity tables and other data sources available on the Clarity server. - CORRECT
ANSWER: Derived tables
______ ______ allow you to preserve multiple versions of the report results on the BOE
server - CORRECT ANSWER: Historical instances
______ ______ determines how many lines of data an item can hold for a single contact
- CORRECT ANSWER: Response Type
______ ______ has the ability to query the Clarity database using an ODBC
connection. - CORRECT ANSWER: Crystal Reports
______ ______ is defined as completing workflows in Hyperspace and making sure that
that data populates the report correctly - CORRECT ANSWER: data seeding
______ ______ is defined as making sure the details in the report match the information
populating the report - CORRECT ANSWER: spot checking
______ (which usually have names that start with "V_") don't hold data in themselves,
but run queries against other Clarity tables and present the results in a form that can be
used as table. - CORRECT ANSWER: Views
______ are subsets of contacts - CORRECT ANSWER: Items
______ are subsets of items - CORRECT ANSWER: Lines
______ are subsets of master files - CORRECT ANSWER: Records
______ are subsets of records - CORRECT ANSWER: Contacts
, ______ control many things about a report, including what master files the query
searches, what criteria are available, and many aspects of the user interface. -
CORRECT ANSWER: Templates
______ exist to store data - CORRECT ANSWER: Items
______ Files are subsets of the Chronicles database - CORRECT ANSWER: Master
______ is like putting a flag on a user telling the batch job they need to see the report
results next time the batch job runs - CORRECT ANSWER: Subscribing
______ items store data directly on a record, not a specific contact - CORRECT
ANSWER: No-Add
______ items store values separately on each contact, but assume that the last value
entered remains true until a new value is entered - CORRECT ANSWER: Lookback
_____is Epic's integrated production database. - CORRECT ANSWER: Chronicles
A ______ ______ ______ can be thought of visually as an inner join, plus all the rows in
the right table that don't have matches in the left. Similarly, it can be thought of as a left
outer join where the tables have changed sides. - CORRECT ANSWER: Right Outer
Join
A ______ ______ ______ will return all rows from both tables with data from each table
if available. It will include rows that have matches in either table as well as those that
don't. It can be thought of visually as everything. - CORRECT ANSWER: Full Outer Join
Latest Update 2025-2026 Exam 190 Questions
with 100% Verified Correct Answers Guaranteed
A+
____ _____ generally put more emphasis on filtering out unnecessary information than
they do on showing a comprehensive picture. - CORRECT ANSWER: Operational
reports
____ _____ is a standardized operational reporting tool that can provide a similar look-
and-feel to reports across applications. - CORRECT ANSWER: Reporting Workbench
_____ is a tool that extracts data from your Chronicles production system, transforms it
into a relational format, and loads it onto a separate reporting server - CORRECT
ANSWER: Clarity
_____ is Epic's information center, a portal that hosts personalizable Home pages to
display Epic data, reports, and links to other pages. - CORRECT ANSWER: Radar
_____ is the programming language on which Chronicles is built - CORRECT
ANSWER: Caché Script
______ ______ ______ can help you identify tables related to a table you already know
- CORRECT ANSWER: Database Object Search
______ ______ ______ items store values separately on each of a record's contacts -
CORRECT ANSWER: Response each time
,______ ______ (which usually have names that start with "F_") are populated by scripts
on Clarity tables and other data sources available on the Clarity server. - CORRECT
ANSWER: Derived tables
______ ______ allow you to preserve multiple versions of the report results on the BOE
server - CORRECT ANSWER: Historical instances
______ ______ determines how many lines of data an item can hold for a single contact
- CORRECT ANSWER: Response Type
______ ______ has the ability to query the Clarity database using an ODBC
connection. - CORRECT ANSWER: Crystal Reports
______ ______ is defined as completing workflows in Hyperspace and making sure that
that data populates the report correctly - CORRECT ANSWER: data seeding
______ ______ is defined as making sure the details in the report match the information
populating the report - CORRECT ANSWER: spot checking
______ (which usually have names that start with "V_") don't hold data in themselves,
but run queries against other Clarity tables and present the results in a form that can be
used as table. - CORRECT ANSWER: Views
______ are subsets of contacts - CORRECT ANSWER: Items
______ are subsets of items - CORRECT ANSWER: Lines
______ are subsets of master files - CORRECT ANSWER: Records
______ are subsets of records - CORRECT ANSWER: Contacts
, ______ control many things about a report, including what master files the query
searches, what criteria are available, and many aspects of the user interface. -
CORRECT ANSWER: Templates
______ exist to store data - CORRECT ANSWER: Items
______ Files are subsets of the Chronicles database - CORRECT ANSWER: Master
______ is like putting a flag on a user telling the batch job they need to see the report
results next time the batch job runs - CORRECT ANSWER: Subscribing
______ items store data directly on a record, not a specific contact - CORRECT
ANSWER: No-Add
______ items store values separately on each contact, but assume that the last value
entered remains true until a new value is entered - CORRECT ANSWER: Lookback
_____is Epic's integrated production database. - CORRECT ANSWER: Chronicles
A ______ ______ ______ can be thought of visually as an inner join, plus all the rows in
the right table that don't have matches in the left. Similarly, it can be thought of as a left
outer join where the tables have changed sides. - CORRECT ANSWER: Right Outer
Join
A ______ ______ ______ will return all rows from both tables with data from each table
if available. It will include rows that have matches in either table as well as those that
don't. It can be thought of visually as everything. - CORRECT ANSWER: Full Outer Join
