You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee.
The table contains employee details, including the sales territory for each employee.
The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services
(AD DS) domain and logon name for each employee.
You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales
territory.
What should you do?

You are developing a SQL Server PowerPivot workbook that sources data from a SQL Azure 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 manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS)
instance in SharePoint integrated mode.
Several report subscriptions are configured to deliver reports through a shared folder by using a shared
schedule.
The shared folder will be going offline.
You need to temporarily suspend the shared schedule until the shared folder is brought back online.
What should you do?

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL
Server.
The data size and complexity of the data relationships will not change.
The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

You are modifying a SQL Server Analysis Service (SSAS) cube.
The cube consist of a single measure group that contains the following measures:
– Total Quantity On Hand
– Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real- time
and that Average Quantity On Hand measure is updated hourly.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
– Queries must be able to return all rows.
– Must be able to support four different processing schedules for different date ranges.- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML.
The report includes a dataset with fields named Description, Price, and Color.
The report layout includes a table that displays product details and also includes columns named Description,
Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?

You are working with a SQL Server Reporting Services (SSRS) instance in native mode.
An item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can view and modify report caching parameters.
Which task should you add to the Developer role?