You work as a database administrator at ABC.com. The ABC.com network contains SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Analysis Services
(SSAS) role that contains a cube.
During routine monitoring, you discover that queries are not performing optimally. You are tasked
with the responsibility of improving the query performance. You are in the process of identifying
the poorly performing queries in order to make the necessary changes to the cube to enhance the
performance.
What should you do? (Choose THREE.)
Each answer forms part of the solution.)
A.
The Usage-Based Optimization Wizard should be used.
B.
The SSAS Transactions log should be used.
C.
The AggregationUsage feature should be modified.
D.
The aggregations should be analyzed.
E.
The aggregations should be designed.
F.
The connection string should be set.