You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.
You need to delete the dimension.
What should you do?

You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processingperformance.
What should you do?

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

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

You are developing a SQL Server Reporting Services (SSRS) report.
The report includes a dataset with fields named Year, MonthNumber, and RegCount.
The report includes a table that displays the number of recorded registration occurrences per year, asshown in
the following diagram.
You need to modify the table to include a graphicalitem displaying the monthly registration trend to the right of
the Reg Count column.
What should you do?

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure
database.
The report must display the value and status of a Key Performance Indicator (KPI).
Which report item should you use? (Each answer presents a complete solution. Choose all that apply.)

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-todate (YTD) grape yield.
Grape yield values are classified in three bands:
– High Yield
– Medium Yield
– Low Yield You add a table to the report.
Then you define two columns based on the fields named VineyardName and YTDGrapeYield.
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape
yield values.
What should you do?

A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security.
A role named USA allows users to browse data pertaining to the United States.
A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to
Canada.
You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.

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

You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described bya status and a trend.
Revenue, goal, status, and trend will be defined byMultidimensional Expressions (MDX) expressions.
You need to add the Revenue indicator.
Which tab should you select? (To answer, select theappropriate tab in the work area.)