You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com.
There is a cube in an SSAS instance.
Because the queries operate not as fast as usual, you should affirm which queries run slowly and change the storage setting of the cube.
Which is the correct answer?
A.
You should run the Cube Storage Wizard to analyze and design aggregations.
B.
You should run the Usage-Based Optimization Wizard to analyze and design aggregations.
C.
You should use SQL Profiler to examine the execution plans to analyze and design aggregations.
D.
You should modify the Data Source Impersonation Info property of the Analysis Services database.
Explanation:
Defining Aggregations with the Usage-Based Optimization Wizard
Recall from Chapter 7, Managing SSAS Storage, Processing, and Deployment, that you can speed up query response times tremendously by designing useful aggregations. An aggregation contains the summarized values of all measures in a measure group by a combination of different attributes. At design time, you can use the Aggregation Design Wizard to define aggregations based on your dimensional design and data statistics. After the cube is in production and representative query statistics are available, you should consider running the Usage-Based Optimization Wizard to fine-tune the aggregation design based on the actual queries submitted to the server.
The Usage-Based Optimization Wizard uses the same cost/benefit algorithm as the Aggregation Design Wizard, but it also performs an additional ranking of the aggregation candidates in the query log. Before running the Usage-Based Optimization Wizard, you need to enable and populate the query log.