You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services
(SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product
Categories hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate
functions from the list of functions to the correct locations in the answer area.)
Select and Place:

You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal,
status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)
Hot Area:

You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to
currency exchange rates. One of the measures in this group is named Average Rate and it will be
used to report the average currency exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange
rate over time.
Which value should you select for the AggregationFunction property for the Average Rate
measure? To answer, select the appropriate setting in the answer area.

Hot Area:

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: