Microsoft
70-466 · Question #104
You need to select a storage mode for each measure group. The solution must meet the following requirements: - The measure group contains a low data volume. - Queries that use the measure group often
In the answer area, for 'Sales History', select 'Automatic MOLAP'. For 'Current Sales', select 'Scheduled MOLAP'.
Configure and maintain an analysis services database
Question
You need to select a storage mode for each measure group. The solution must meet the following requirements: - The measure group contains a low data volume. - Queries that use the measure group often reference non-aggregate data. - The measure group includes SUM, MIN, MAX, and COUNT aggregate functions. You need to select a storage mode for each measure group. What should you do? To answer, select the appropriate storage mode for each measure group in the answer area.
Explanation
In the answer area, for 'Sales History', select 'Automatic MOLAP'. For 'Current Sales', select 'Scheduled MOLAP'.
Topics
#storage mode#MOLAP#ROLAP#HOLAP
Community Discussion
No community discussion yet for this question.