You have a data warehouse named DW1.
An OLAP cube named Cube1 uses DW1 as its data source. Cube1 uses the MOLAP
storage mode.
You create a SQL Server Integration Services (SSIS) package that updates DW1, and then
processes Cube1. The package executes each day at 06:00.
You need to configure the storage settings of Cube1. The solution must ensure that
aggregation processing is reduced as much as possible during cube querying.
What is the best storage setting you should you use for Cube1? More than one answer
choice may achieve the goal. Select the BEST answer.
A.
Medium-latency MOLAP
B.
Scheduled MOLAP
C.
Low-latency MOLAP
D.
Automatic MOLAP
B
+1
B is correct, a new processing every 24 hrs.
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/set-partition-storage-analysis-services-multidimensional