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
Someone can explain the question and the answer?
https://msdn.microsoft.com/en-us/library/ms175646%28v=sql.110%29.aspx
MOLAP is the correct answer:
“Proactive caching is not enabled. Detail data and aggregations are stored in multidimensional format. The server does not receive notifications when data changes. Processing must either be scheduled or performed manually.”
Why not B?
Automatic MOLAP
Detail data and aggregations are stored in multidimensional format. The server listens for notifications but retains the current MOLAP cache while it builds a new one. The server never switches to real-time OLAP, and queries may be stale while the new cache is built.
A silence interval of at least 10 seconds is required before creating the new MOLAP cache. There is an override interval of 10 minutes if the silence interval is not attained. Processing occurs automatically as data changes with a target latency of two hours.
This setting is typically used for a data source when query performance is of key importance. This setting automatically processes MOLAP objects whenever required after the latency interval. Queries do not return the most recent data while the new cache is being built and processed.
Scheduled MOLAP
Detail data and aggregations are stored in a multidimensional format. The server does not receive notifications when data changes. Processing occurs automatically every 24 hours.
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.
B
DW1, the source of for the cube is only updated once a day. Hence Automatic MOLAP will be useless.
Scheduled MOLAP is the correct answer.
Agree