CLR 110 PART 5: EXPLORING
DATABASE OBJECTS IN CLARITY WITH
COMPLETE SOLUTIONS
_____________s are the most common database object in Clarity. The Clarity data
model simplifies the Clarity ETL process, allowing data to move efficiently from
Chronicles to Clarity. - ANSWER-Extracted table
One helpful tool you can use to discover whether or not there is a view or derived table
that meets a specific reporting need is Epic's released ________________ - ANSWER-
Entity Relationship Diagrams, or ER Diagrams.
An ______________ is a visual tool that shows relationships between database objects
relevant to a particular reporting area. - ANSWER-ER diagram
ER diagrams contain information such as: - ANSWER-1. Common tables and their links
for a particular reporting area
2. Relationship cardinality of frequent joins
To find the er diagrams, search for ________________ - ANSWER-"<application> ER
Diagram htm" on Galaxy
When investigating a view or derived table that looks potentially useful for your reporting
needs, it is important to _____________ - ANSWER-conduct research into the
underlying data.
One of the quickest ways to scope out the underlying data for a view or derived table is
to check the _____________ - ANSWER-Dependent Database Objects section of the
summary tab.
Views in Clarity typically begin with - ANSWER-V_"
Derived tables follow the dimensional data model: - ANSWER-fact tables begin with F_
and dimension tables begin with D_,
views typically being with - ANSWER-V_
Epic SQL Functions will be found in the ____________ but they are not found in the
Clarity Dictionary - ANSWER-Clarity Compass
____________ are not constrained by the rules of the Clarity Data Model. - ANSWER-
views and derived tables
DATABASE OBJECTS IN CLARITY WITH
COMPLETE SOLUTIONS
_____________s are the most common database object in Clarity. The Clarity data
model simplifies the Clarity ETL process, allowing data to move efficiently from
Chronicles to Clarity. - ANSWER-Extracted table
One helpful tool you can use to discover whether or not there is a view or derived table
that meets a specific reporting need is Epic's released ________________ - ANSWER-
Entity Relationship Diagrams, or ER Diagrams.
An ______________ is a visual tool that shows relationships between database objects
relevant to a particular reporting area. - ANSWER-ER diagram
ER diagrams contain information such as: - ANSWER-1. Common tables and their links
for a particular reporting area
2. Relationship cardinality of frequent joins
To find the er diagrams, search for ________________ - ANSWER-"<application> ER
Diagram htm" on Galaxy
When investigating a view or derived table that looks potentially useful for your reporting
needs, it is important to _____________ - ANSWER-conduct research into the
underlying data.
One of the quickest ways to scope out the underlying data for a view or derived table is
to check the _____________ - ANSWER-Dependent Database Objects section of the
summary tab.
Views in Clarity typically begin with - ANSWER-V_"
Derived tables follow the dimensional data model: - ANSWER-fact tables begin with F_
and dimension tables begin with D_,
views typically being with - ANSWER-V_
Epic SQL Functions will be found in the ____________ but they are not found in the
Clarity Dictionary - ANSWER-Clarity Compass
____________ are not constrained by the rules of the Clarity Data Model. - ANSWER-
views and derived tables
