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…

Question

Options

• AYou should run the Cube Storage Wizard to analyze and design aggregations.
• BYou should run the Usage-Based Optimization Wizard to analyze and design aggregations.
• CYou should use SQL Profiler to examine the execution plans to analyze and design aggregations.
• DYou should modify the Data Source Impersonation Info property of the Analysis Services database.

• A
  3% (2)
• B
  80% (49)
• C
  11% (7)
• D
  5% (3)

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

No community discussion yet for this question.