You need to configure ABC-Cube1 to use proactive caching and ensure the cache is updated when the data changes after waiting for the default 10 second silence interval

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). You have an SSAS cube named ABC-Cube1.
You need to configure ABC-Cube1 to use proactive caching and ensure the cache is
updated when the data changes after waiting for the default 10 second silence interval.
Data that has been cached for more than 30 minutes should be dropped and the storage of
the data and aggregations in the cube must be optimized.
What should you do?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). You have an SSAS cube named ABC-Cube1.
You need to configure ABC-Cube1 to use proactive caching and ensure the cache is
updated when the data changes after waiting for the default 10 second silence interval.
Data that has been cached for more than 30 minutes should be dropped and the storage of
the data and aggregations in the cube must be optimized.
What should you do?

A.
You should set the partition storage setting to Real-time ROLAP.

B.
You should set the partition storage setting to Real-time HOLAP.

C.
You should set the partition storage setting to Low-latency MOLAP.

D.
You should set the partition storage setting to Scheduled MOLAP.

E.
You should set the partition storage setting to MOLAP.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Mahmoud Ibrahim

Mahmoud Ibrahim

C