You need to ensure that the aggregations are optimal

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 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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Ralph

Ralph

MS recommend using the Usage Based Optimization Wizard
The tool was designed for such purpose.
“A”

Marchello

Marchello

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.