CLR 110 Part 5: Exploring Database
Objects in Clarity
____________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. - CORRECT 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 ________________ - CORRECT
ANSWER-Entity Relationship Diagrams, or ER Diagrams.
An ______________ is a visual tool that shows relationships between database objects
relevant to a particular reporting area. - CORRECT ANSWER-ER diagram
ER diagrams contain information such as: - CORRECT 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 ________________ - CORRECT ANSWER-
"<application> ER Diagram htm" on Galaxy
views typically being with - CORRECT ANSWER-V_
Recall from the Other Database Objects section of the RPT101i SQL I self-study that a
view is a _________________ - CORRECT ANSWER-stored query.
_____________, in Clarity are populated from queries that run against data already
contained in the database and can take the place of several tables in one report. In Clarity,
derived tables follow the dimensional data model: fact tables begin with F and dimension
tables begin with D - CORRECT ANSWER-Derived tables, or materialized views
