Microsoft
70-448 · Question #135
70-448 Question #135: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #135. The question stem and answer options stay visible for context.
Question
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?
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.