Câu 28: 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

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

1. 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. — đáp án hiện tại
2. 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.
3. 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.
4. D. Set the AggregationUsage property of all attributes based on natural keys to Full.