You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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:

You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute in the
answer area.

Hot Area:

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

You are developing a SQL Server Analysis Services (SSAS) 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 tblOrders.
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.)
Select and Place:

You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a

running team.
The data warehouse used by the cube contains the time durations of laps run by each runner on
the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
A measure named Measure1 that must contain the average time duration of the laps run by
each runner.
A measure named Measure2 that must contain the lap-time duration and the name of the runner
who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each
measure in the answer area.

Hot Area:

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

You are planning the installation of PowerPivot for SharePoint.
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.)
Select and Place:

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:

You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension 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.)
Select and Place:

You have a database named DB1. DB1 contains four tables named FactSales, DimTime,
DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.

A sample from DimCustomer is shown in the following table.

A sample from FactSales is shown in the following table.

You need to identify which type of dimension must be created for each table.
Which type of dimension should you create for each table? To answer, drag the appropriate
dimensions to the correct tables. Each dimension may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
Select and Place: