Microsoft
70-466 · Question #58
70-466 Question #58: Real Exam Question with Answer & Explanation
The correct answer is A: Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.. To support different update frequencies for measures in a single MOLAP measure group, you must separate them into distinct measure groups with different storage modes.
Configure and maintain an analysis services database
Question
You are modifying a SQL Server Analysis Service (SSAS) cube. The cube consist of a single measure group that contains the following measures: - Total Quantity On Hand - Average Quantity On Hand The measure group has a single partition that uses the MOLAP storage mode. You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time, and that Average Quantity On Hand measure is updated hourly. What should you do?
Options
- ACreate a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
- BCreate an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
- CChange the storage mode of the partition to use proactive caching with minimum latency.
- DCreate a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
Explanation
To support different update frequencies for measures in a single MOLAP measure group, you must separate them into distinct measure groups with different storage modes.
Common mistakes.
- B. Continuously executing an XMLA process script via SQL Agent is not a real-time update mechanism and imposes excessive load without providing true real-time results.
- C. Proactive caching with minimum latency applies to the entire partition and cannot differentiate update frequencies between individual measures within the same measure group.
- D. This is backwards - it assigns ROLAP (real-time) to Average Quantity On Hand, which only needs hourly updates, while leaving Total Quantity On Hand in the MOLAP partition that requires manual processing.
Concept tested. SSAS MOLAP vs ROLAP storage mode per measure group
Topics
#ROLAP storage#real-time updates#measure groups#mixed latency requirements
Community Discussion
No community discussion yet for this question.