Microsoft Implementing Data Models and Reports with Microsoft SQL Server (70-466日本語版) - 70-466日本語 Exam Practice Test

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Explanation:
Box 1: On the Partitions tab, Click Storage Settings
We specify the Storage Settings for the correct partition.
Box 2: Enable proactive caching.
We enable proactive caching.
Box 3: Select the Client initiated notification type, and then select the tblOrders table.
On the Notifications tab, there are three options out of which, as shown below, you can select any one at a time.
* SQL Server - With this option, SSAS uses SQL Server notification services/specialized trace mechanism to identify data changes.
* Client initiated - With this option, client can specify the XMLA (XML for Analysis) command (NotifyTableChange) to identify data changes.
* Scheduled polling - With this option, SSAS uses a series of queries to see (polling at defined interval) if there is any data change at the underlying relational database.

Note:
You use the Storage Settings dialog box in BIDS (Business Intelligence Development Studio) to set the proactive caching feature, storage location, and notification settings for a dimension, cube, measure group, or measure group partition.
* In the Cube Browser, open your cube and select the Partitions tab.
* Expand the measure group and select the partition for which you want to enable proactive caching.
* Click the Storage Setting link to open the Partition Storage Settings dialog box similar to the one as shown in below image. (Box 1)

The Custom Setting allows you to explicitly enable proactive caching (if you don't want to use Standard Setting), set storage mode, and notification options. (Box 2)