CLR 110 Part 5: Exploring Database Objects in Clarity Questions & Answers Correctly Answered.

____________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 viewsThe _________________ 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 If you have reports that are taking a particularly long time to run, one recommended practice is replacing any Epic Standard SQL Functions used in the report with ________________ - CORRECT ANSWER-vendor-specific functions.