Microsoft
70-467 · Question #38
70-467 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
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.)
Options
- AEnable SQL Server Analysis Services (SSAS) query logging.
- BSet up multiple partitions.
- CSet up multiple partitions.
- DSet the AggregationUsage property of all attributes based on natural keys to Full.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 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.