Microsoft
70-467 · Question #176
70-467 Question #176: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #176. The question stem and answer options stay visible for context.
Question
You are designing a partitioning strategy for a SQL Server Analysis Services (SSAS) cube. New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 million and 15 million rows of data are loaded into the main fact table each day from a Microsoft Azure SQL Database. You have the following requirements: - Maximize cube query performance during business hours. - Ensure that data is available in the cube as soon as possible after it is loaded into the data warehouse. You need to design a partitioning strategy that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- APartition the cube by day for history, using hybrid OLAP (HOLAP) storage mode.
- BPartition the cube by week for history.
- CPartition the cube by day for history, using multidimensional OLAP (MOLAP) storage mode.
- DPartition the cube by day for history, using multidimensional OLAP (MOLAP) storage mode.
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.