You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database. You plan to use multiple servers to process different par

1. Open the cube for editing, select the Partitions tab, and then click New Partition. 2. Click Enable Proactive caching and then select the HOLAP storage mode. 3. Select the table and then specify the query for the new partition. 4. Create a linked server for the remote processi

Build an analysis services database

Question

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database. You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source. You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition. 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

Open the cube for editing, select the Partitions tab, and then click New Partition.
Click Enable Proactive caching and then select the HOLAP storage mode.
Select the table and then specify the query for the new partition.
Create a linked server for the remote processing location.
Click Storage Settings and then click Options to open the Storage Options dialog box.
On the Processing and Storage Locations step, ensure that the processing location is set to the Remote Analysis Services data source.

Topics

#SSAS remote partitions#parallel partition processing#data source configuration#multidimensional partitioning

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice