Microsoft
70-467 · Question #77
70-467 Question #77: Real Exam Question with Answer & Explanation
The correct answer is B: Implement monthly remote partitions.. As a cube grows, remote partitions distribute storage and query processing across multiple servers, providing the horizontal scalability that local partitions cannot.
Question
You need to design a cube partitioning strategy to be implemented as the cube size increases. What should you do?
Options
- AUse relational OLAP (ROLAP) on all local partitions.
- BImplement monthly remote partitions.
- CUse multidimensional OLAP (MOLAP) on all local partitions.
- DImplement monthly local partitions.
Explanation
As a cube grows, remote partitions distribute storage and query processing across multiple servers, providing the horizontal scalability that local partitions cannot.
Common mistakes.
- A. ROLAP stores aggregations in the relational database rather than SSAS multidimensional storage, but using it on local partitions does not address the need to distribute data across servers as cube size grows.
- C. MOLAP on local partitions provides the best query performance within a single server, but keeping all partitions local does not enable horizontal scaling as cube size increases significantly.
- D. Monthly local partitions improve query performance through partition pruning and simplify incremental processing, but all data remains on a single server, which does not solve the scaling problem.
Concept tested. SSAS cube scale-out using remote partitions
Community Discussion
No community discussion yet for this question.