You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure
database and a SQL Server Analysis Services (SSAS) cube.
The cube contains a date dimension and other dimensions.
The report design includes two report parameters named StartDate and FinishDate as shown in the following
diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube.
You also need to ensure that the dataset is filtered by the existing report parameters.
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 Reporting Services (SSRS) report to display a list of employees.
The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.
The report consists of a single table.
The design of the table is shown in the following diagram.
You need to configure the EmailAddress detail text box to create a new email message.
The email message must be addressed to the email address that was clicked by the user.
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.)

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.)