PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a cube in an SSAS instance. You notice that the queries run slowly. You need to identify the queries that run slowly and change the storage configuration of the cube. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Run the Cube Storage Wizard to analyze and design aggregations.

B.
Run the Usage-Based Optimization Wizard to analyze and design aggregations.

C.
Use SQL Profiler to examine the execution plans to analyze and design aggregations.

D.
Modify the Data Source Impersonation Info property of the Analysis Services database.


Leave a Reply