You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.
The production database has been configured with security roles.
You need to preserve the existing security roles inthe production database.
Database roles and their user accounts from the development environment must not be deployed to the
production server.
Which deployment method should you use?

You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for theSalesAmount measure is four digits.
You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast
data sourced from a financial database.
The model will be deployed to a server with 32 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 10 terabytes of disk spaceand is
doubling in size every three months.
The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

You are developing a BI Semantic Model (BISM) that retrieves data from several sources.
These sources include a SQL Azure database and an OData data feed that includes rainfall data for towns on
the east coast of Australia.
The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use whendeveloping the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
– Performance must be maximized.
– Data latency of up to one month is acceptable.
You need to choose a project type and a data accessmode to meet the requirements.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model has tables named Invoice Line Items and Products.
The Invoice Line Items table has the following columns:
– Product Id
– Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
– Product Id
– Maximum Sales Price
The Maximum Sales Price column is available only inthe Products table.
You add a column named Is Overpriced to the InvoiceLine Items table.
The Is Overpriced column must store a value of TRUEif the value of the Unit Sales Price is greater than the
value of the Maximum Sales Price.
Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

You are designing a SQL Server Reporting Services (SSRS) report for a bank.
The bank has Automated Teller Machines (ATMs) in several regions.
ATM operational data is stored in a SQL Azure database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit.
(Click the Exhibit button.)

You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for themap?

You manage a SQL Server Reporting Services (SSRS) instance.
The ReportingServicesService.exe.config file has been modified to enable logging.
Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the server.
What should you do?

You are planning the installation of PowerPivot forSharePoint.
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 themin the
correct order.)

You are developing reports based on the SQL Server Analysis Services (SSAS) cube named
Orders.
A Multidimensional Expressions (MDX) query must include a query-scoped calculated member, which
computes average sales per order item.
The query must also return the set of three states in a query-scoped named set named East Coast Customers.
You need to define the calculations in an MDX queryto meet the requirements.
Which four MDX segments should you insert in sequence before a SELECT statement?
(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.
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.)