Microsoft Exam 70-467 Topic 10 Question 4 Discussion

Actual exam question for Microsoft's 70-467 exam

Question #: 4
Topic #: 10

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day.

You have the following requirements:

Ensure that the cube displays current data as quickly as possible.

Maximize availability of the cube.

Maximize query performance for all aggregation levels.

You need to choose a partitioning strategy that meets the requirements.

Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

ACreate one partition for the current day that uses multidimensional OLAP (MOLAP) with proactive caching as a storage mode.

BCreate one partition for the current month that uses hybrid OLAP (HOLAP) as a storage mode.

CCreate one partition for the current day that uses relational OLAP (ROLAP) as a storage mode.

DCreate one partition for the current day that uses multidimensional OLAP (MOLAP) as a storage mode. Process the partition each night.

Show Suggested Answer

Suggested Answer: A

by Talia at May 08, 2022, 05:52 PM

Limited Time Offer

25%

Off

Get Premium 70-467 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!