nerdexam
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.

Full 70-466 Practice