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.)
Select and Place:

Answer:

Explanation:
Note:
* You create a remote partition using the Partition Wizard. On the Specify Processing and Storage
Options page, for the Remote Analysis Services data source, specify the dedicated database on
the remote instance of Analysis Services. This instance of Analysis Services is called the remote
server of the remote partition. For Storage location, you can specify the default data location for
the remote server or a specified folder on the server.
You must create an Analysis Services database on the remote server and provide appropriate
security settings. An additional OLAP data source is created on the remote database pointing to
the server on which the partition is defined. The MasterDatasourceID property setting on the
remote database points to the data source which, in turn, points to the master server. This
property is only set on a database that contains remote partitions. The RemoteDatasourceID
property setting on the remote partition specifies the ID of the OLAP data source on the master
server that points to the remote server. A remote database can only host remote partitions for a
single server.
* Before you create a remote partition, the following conditions must be met:
The domain user account for the local instance of Analysis Services must have administrative
access to the remote database.
Creating and Managing a Remote Partition