You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a large data warehouse named CorpDW. New data is added to a fact
table named CurrentInfo in the data warehouse throughout the day.
A server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). You have
an SSAS cube named ABC-Cube1 which contains a measure group supported by the
CurrentInfo fact table.
You need to configure the partitioning for the cube to optimize query performance across
all aggregation levels whilst ensuring the cube is available as much as possible and
displays the most up-to-date data as quickly as possible.
You plan to create a single partition to host the current day’s data.
How should you configure the partition?
A.
Select HOLAP (Hybrid OLAP) as the storage mode.
B.
Select ROLAP (Relational OLAP) as the storage mode.
C.
Select MOLAP (Multidimensional OLAP) as the storage mode and schedule the partition
processing to run every night.
D.
Select MOLAP (Multidimensional OLAP) as the storage mode and select the proactive caching
mode.
Explanation:
“optimize query performance across
all aggregation levels whilst ensuring the cube is available as much as possible and
displays the most up-to-date data as quickly as possible.”
A.
Select HOLAP (Hybrid OLAP) as the storage mode.
Agree, should be A.