You are developing a SQL Server Analysis Services (SSAS) cube. The cube consists of a single measure group. The measure group consists of one partition that uses MOLAP. The proactive caching policy ha

The correct sequence of actions to configure the proactive caching policy to meet the requirements is: 1. On the Partitions tab, Click Storage Settings. (This allows access to the proactive caching settings for the partition.) 2. Enable proactive caching. (This activates the proa

Configure and maintain an analysis services database

Question

You are developing a SQL Server Analysis Services (SSAS) cube. The cube consists of a single measure group. The measure group consists of one partition that uses MOLAP. The proactive caching policy has the following requirements: - The cache must be updated when data is changed in the table named tblOrders. - Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command. You need to configure the proactive caching policy to meet the requirements. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Explanation

The correct sequence of actions to configure the proactive caching policy to meet the requirements is:

On the Partitions tab, Click Storage Settings. (This allows access to the proactive caching settings for the partition.)
Enable proactive caching. (This activates the proactive caching feature.)
Select the Client initiated notification type, and then select the tblOrders table. (This ensures that changes in tblOrders are notified via the XMLA NotifyTableChange command, fulfilling the requirement for client-initiated notification when data changes.)

Topics

#proactive caching#MOLAP partition#XMLA NotifyTableChange#cache policy

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice