Microsoft
70-466 · Question #146
70-466 Question #146: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #146. The question stem and answer options stay visible for context.
Configure and maintain an analysis services database
Question
A multidimensional SQL Server Analysis Services (SSAS) database will be tested next week. During the test period, users will access the database for 30 days. Multidimensional Expressions (MDX) queries generated during the test period must represent the variety of queries that will be used in the production environment. After testing completes, you need to implement aggregations for every partition in the solution while minimizing development effort. You need to ensure that the aggregations are optimal. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ASet up a query log and record all user queries during the test period. After completion of the test, use the Usage Based Optimization Wizard to define aggregations for each partition.
- BDuring the test period, identify long-running queries by using SQL Server Profiler. Use those queries to design aggregations by using the DesignAggregations command in XML for Analysis (XMLA).
- CDuring the test period, run SQL Server Profiler for 10 minutes every day and record all queries executed in those 10 minutes. Use the aggregation Design Wizard to design the aggregations.
- DDevelop a SQL Server Integration Services (SSIS) package by using a Script task and then use Analysis Management Objects (AMO) to design the aggregations.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 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.
Topics
#SSAS aggregations#Usage Based Optimization#query log#partition optimization