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.