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.)
A. Set 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.
B. During 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).
C. During 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.
D. Develop a SQL Server Integration Services (SSIS) package by using a Script task and then use Analysis Management Objects (AMO) to design the aggregations.
