A. Identity Store
B. Credential Store
C. Person Store
D. Policy Store
A. Logical Key
B. Alias
C. Custom Display Name
D. Implicit Fact Column
E. Logical Column Name
A. Top Customers by Revenue
B. ETL Load Date
C. OLAP DSN
D. User Organization
A. Value-based Hierarchy
B. Ragged Hierarchy
C. Level-based Time Dimension hierarchy
D. Skip Level Hierarchy
A. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.
B. Aggregate tables are created and stored on the BI Server.
C. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.
D. Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.
A. decrease query response time
B. improve Analysis data quality
C. eliminate Write Back Capabilities
D. create Aggregate tables
E. improve performance of Dashboards and Analysis
