You are designing a multidimensional OLAP (MOLAP) cube.
The MOLAP cube must meet the following requirements:
Ensure that workloads for aggregation tuning can be automatically collected.
Require the least amount of effort to perform manual aggregation tuning.
Minimize impact on the performance of previously tuned queries.
You need to design a MOLAP cube that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Enable SQL Server Analysis Services (SSAS) query logging. Run the Usage-Based
Optimization Wizard to generate aggregations. Merge the wizard results with existing
aggregation designs.
B.
Set up multiple partitions. Run the Aggregation Design Wizard periodically for each
measure group. After the wizard finishes, discard the old aggregation design and accept the
new one.
C.
Set up multiple partitions. Run the Aggregation Design Wizard on each partition.
Schedule the aggregations by using an XMLA script in SQL Server Agent.
D.
Set the AggregationUsage property of all attributes based on natural keys to Full.
Explanation: