Non‐Extracted Tables and Documentation Flashcards
What is a view in Clarity?
A) A stored procedure
B) A stored query
C) A materialized view
D) A physical table
B) A stored query
What is a derived table in Clarity?
A) A stored procedure
B) A stored query
C) A materialized view
D) A physical table
C) A materialized view
Which section of the Data Dictionary provides a list of Clarity tables and columns that form the underlying structure of a view or derived table?
A) Overview
B) Columns
C) Dependencies
D) Queries
C) Dependencies
What is the primary key structure for views and derived tables in Clarity?
A) Fixed and predefined
B) Flexible and can vary widely
C) Always includes Record ID
D) Always includes CSN
B) Flexible and can vary widely
Which naming convention is typically used for fact tables in Clarity?
A) V_
B) D_
C) F_
D) T_
C) F_
Which of the following are types of non-extracted tables in Clarity?
A) Views
B) Derived tables
C) Extracted tables
D) Materialized views
A) Views
B) Derived tables
D) Materialized views
Which characteristics can describe a view in Clarity?
A) Stored query
B) Physical table
C) Combines data from multiple tables
D) Begins with “V_”
A) Stored query
C) Combines data from multiple tables
D) Begins with “V_”
Which of the following are true about derived tables in Clarity?
A) They are physically saved to the database.
B) They are populated from queries.
C) They follow the dimensional data model.
D) They are always materialized views.
A) They are physically saved to the database.
B) They are populated from queries.
C) They follow the dimensional data model.
What information can be found in the Dependencies section of the Data Dictionary for a view or derived table?
A) List of Clarity tables and columns
B) SQL queries responsible for populating the view or derived table
C) Data lineage information
D) List of dependent database objects
A) List of Clarity tables and columns
D) List of dependent database objects
Which of the following are true about the Queries section of the Data Dictionary for a view or derived table?
A) Displays the SQL queries responsible for populating the view or derived table.
B) Provides data lineage information.
C) Lists the primary keys of the view or derived table.
D) Shows the dependencies of the view or derived table.
A) Displays the SQL queries responsible for populating the view or derived table.
Views in Clarity are stored queries that can be investigated in the Queries section of the Data Dictionary.
True
False
True
Derived tables in Clarity are also known as materialized views.
True
False
True
The primary key structure for views and derived tables in Clarity is fixed and predefined.
True
False
False
The Dependencies section of the Data Dictionary provides a list of Clarity tables and columns that form the underlying structure of a view or derived table.
True
False
True
The Queries section of the Data Dictionary shows the SQL queries responsible for populating the view or derived table.
True
False
True
What is the purpose of the Epic Standard SQL Functions?
A) To accommodate both Microsoft SQL Server and Oracle syntax
B) To create custom reports
C) To manage user permissions
D) To define the structure of Clarity tables
A) To accommodate both Microsoft SQL Server and Oracle syntax
Where can you find reference information about Epic Standard SQL Functions?
A) Analytics Catalog
B) Clarity Compass
C) Data Dictionary
D) Report Repository
B) Clarity Compass
Which of the following is an example of an Epic Standard SQL Function?
A) EFN_DIN
B) EFN_SUBSTR
C) EFN_DATE
D) EFN_STRING
A) EFN_DIN
B) EFN_SUBSTR
What is the purpose of the Report Repository?
A) To store SQL queries
B) To provide reference information for reporting content
C) To manage user permissions
D) To define the structure of Clarity tables
B) To provide reference information for reporting content
Which section of the Data Dictionary would you use to investigate the SQL queries responsible for populating a view or derived table?
A) Overview
B) Columns
C) Dependencies
D) Queries
D) Queries
Which of the following are true about Epic Standard SQL Functions?
A) They are unique to Clarity.
B) They are stored in the EPIC_UTIL schema.
C) They can be found in the Analytics Catalog.
D) They are used to accommodate both Microsoft SQL Server and Oracle syntax.
A) They are unique to Clarity.
B) They are stored in the EPIC_UTIL schema.
D) They are used to accommodate both Microsoft SQL Server and Oracle syntax.
Which of the following are true about the Report Repository?
A) It contains reference information for Epic-released reporting content.
B) It contains reference information for customer-written reporting content.
C) It provides definitions of specific tables or columns.
D) It can be accessed from the UserWeb toolbar.
A) It contains reference information for Epic-released reporting content.
B) It contains reference information for customer-written reporting content.
D) It can be accessed from the UserWeb toolbar.
Which of the following are true about the Dependencies section of the Data Dictionary?
A) It lists Clarity tables and columns that form the underlying structure of a view or derived table.
B) It provides data lineage information.
C) It shows the SQL queries responsible for populating the view or derived table.
D) It lists dependent database objects.
A) It lists Clarity tables and columns that form the underlying structure of a view or derived table.
D) It lists dependent database objects.
Which of the following are true about the Queries section of the Data Dictionary?
A) It displays the SQL queries responsible for populating the view or derived table.
B) It provides data lineage information.
C) It lists the primary keys of the view or derived table.
D) It shows the dependencies of the view or derived table.
A) It displays the SQL queries responsible for populating the view or derived table.
Which of the following are true about views in Clarity?
A) They are stored queries.
B) They can combine data from multiple tables.
C) They are physically saved to the database.
D) They typically begin with “V_”.
A) They are stored queries.
B) They can combine data from multiple tables.
D) They typically begin with “V_”.
Epic Standard SQL Functions are unique to Clarity and can be found in the Analytics Catalog.
True
False
False
The Report Repository contains reference information for both Epic-released and customer-written reporting content.
True
False
True
The Dependencies section of the Data Dictionary provides data lineage information.
True
False
False
The Queries section of the Data Dictionary shows the SQL queries responsible for populating the view or derived table.
True
False
True
Views in Clarity are physically saved to the database.
True
False
False
