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
“The package executes each day at 06:00.”
B. Scheduled MOLAP
Schedule Molap runs every 24 hours
Scheduled MOLAP updates 24 hours from the end of the last processing…meaning that the processing will gradually shift later and later each day.
https://msdn.microsoft.com/en-us/library/ms175646.aspx
i would say scheduled molap (b)
‘This setting is typically used for a data source when only daily updates are required. Queries are always against data in the MOLAP cache, which is not discarded until a new cache is built and its objects are processed.’
I’m not sure if any of these are correct. The answer should be MOLAP. We don’t need proactive caching because we are handling cube processing via SSIS.