You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customerdimension to evaluate the sum of values for Franceand
Germany.

Which expression should you use? (To answer, drag the appropriate expression to the answer area.)

You are planning the installation of PowerPivot forSharePoint that will be used by your company s sales and
marketing team.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance.
Then you need to configure the Default Account username used to provision shared services in the SharePoint
farm.
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.)

You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance.
You are planning to upgrade the instance to SQL Server 2012.
You need to import an existing PowerPivot workbook to create a tabular project.
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.)

You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to
source data from a SQL Azure database.
The largest partition in the cube takes an unacceptably long time to process.
The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to
satisfy the query.
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.)

You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database. In SQL Server Data Tools (SSDT).
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.)

You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customerdimension to evaluate the sum of values for the United
Kingdom and the United States. Which expression should you use?
(To answer, drag the appropriate expression to the answer area.)

You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance that stores databases used by a
financial application.
You are planning to upgrade the instance to SQL Server 2012.
You need to import an existing PowerPivot workbook to create a tabular project.
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.)

You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
While processing a very large tabular model, you receive an out-of-memory error.
You identify that the amount of physical memory in the server is insufficient.
Additional physical memory cannot be installed in the server.
You need to configure the server to allow paging todisk by using the operating system page file (pagefile.sys).
Which four 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.)