DRAG DROP
You are developing a SQL Server Analysis Services (SAS) 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.)

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

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and
tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The
project will be deployed to a SSAS server that has 16 GB of RAM.
The project will source data from a SQL Server database that contains a fact table named
Sales. The fact table has more than 60 billion rows of data.
You need to select an appropriate design to maximize query performance.
Which data access strategy should you use? (More than one answer choice may achieve
the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a
tabular model.
Which role permission should you use?

You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft
Azure SQL Database database. The PowerPivot model includes a single table named
FactSales that consists of four columns named Year, Country, Product and Revenue. The
model includes the following two measures.
Sales:=SUM(FactSales[Revenue])
Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.

Users report that the Sales % measure computes an incorrect ratio. The measure should
meet a requirement to compute a ratio over all visible sales values defined by the query
filters. The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?

You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize
performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?

You are developing a SQL Server Analysis Services (SSAS) tabular project.

In the data warehouse, a table named Employee Security defines a relationship between a
salesperson’s name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory
assigned to that salesperson. You also need to minimize the development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You develop a SQL Server Analysis Services (SSAS) tabular project.The tabular model
loads data from a SQL Server relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one
answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project.

A column named City must be added to the table named Customer. The column will be used
in the definition of a hierarchy. The City column exists in the Geography table that is related
to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?