CLR 110 Part 5: Exploring Database Objects in Clarity Questions with Correct Answers

_____________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 The _________________ are a library of User Defined Functions (UDFs) developed and released by Epic to accommodate both Microsoft SQL Server and Oracle syntax Correct Answer Epic Standard SQL Functions