Microsoft
70-467 · Question #5
70-467 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Design BI data models
Question
A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day. You have the following requirements: - Ensure that the cube displays current data as quickly as possible. - Maximize availability of the cube. - Maximize query performance for all aggregation levels. You need to choose a partitioning strategy that meets the requirements. Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ACreate one partition for the current day that uses multidimensional OLAP (MOLAP) with
- BCreate one partition for the current month that uses hybrid OLAP (HOLAP) as a storage
- CCreate one partition for the current day that uses relational OLAP (ROLAP) as a storage
- DCreate one partition for the current day that uses multidimensional OLAP (MOLAP) as a
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.
Topics
#SSAS partitioning#MOLAP#ROLAP#HOLAP