DRAG DROP
You are developing a SQL Server Analysis Services (S5AS) 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 tbIOrders.
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.)
Answer: See the explanation.
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.
1. In the Cube Browser, open your cube and select the Partitions tab.
2. Expand the measure group and select the partition for which you want to enable
proactive caching.
3. 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)
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image01512.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0197.jpg
How exactly you can click storage setting in partitions tab?
You click on a partition and then on proactive caching.
I think the first step should be “open the partition storage settings”
There is an icon of storage settings in partitions tab, but in order to click on it you have click on a specific partition before.
So i think the “open partition storage setting” is more correct.
D C B
Sorry for confusion D C F
A little confused. The last step is “select measure group” or “measure group and dimension” ?
C => I think is “select measure group”. I can see the answer of Carlos Escobar.
measure group and dimension
Yes, you must choose measure group and dimension because you import a measure group.
You select only the dimension for a linked dimension.
Agree measure group and dimension else there is no point to link Measure group