You are modifying a SQL Server Analysis Services (SSAS) cube.
The cube consists 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 designing a SQL Server Reporting Services (SSRS) report to display product names and their year-todate (YTD) sales quantity.
YTD sales quantity values are classified in three bands: High Sales, Medium Sales, and Low Sales.
You add a table to the report.
Then you define two columns based on the fields named ProductName and YTDSalesQuantity.
You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales
quantity values.What should you do?

You are managing a SQL Server Reporting Services (SSRS) instance in native mode.
A role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task.
When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role so that the role members can view folders.
Which task should you add to the Folder Access Controller role?

You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a SQL Azure database in the report.
What should you do?

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 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?

A production SQL Server Analysis Services (SSAS) cube is processed daily.
The users query facts by using a hierarchy named Geography from a dimension named Geography.
The DimGeography table in the data source view is used as the source of the Geography dimension.
The table has the following structure :
CREATE TABLE [dbo].[DimGeography](
[DimensionKey] [int] IDENTITY(1,1) NOT NULL,
[CityKey] [int] NOT NULL,
[CityName] [varchar](50) NOT NULL,
[StateProvinceKey] [int] NOT NULL,
[StateProvinceName] [varchar](50) NOT NULL,
[CountryKey] [int] NOT NULL,
[CountryName] [varchar](50) NOT NULL) ON [PRIMARY]
The Geography dimension has three attribute hierarchies:
– City
– State-Province
– Country
The attributes have the following relationships defined:
City > State-Province > Country.
Each attribute has a key and a name sourced from the related key and name columns in the DimGeography
table.
During processing, you receive the following error message: “Errors in the OLAP storage engine: A duplicate
attribute key has been found when processing: Table: ‘dbo_DimGeography’, Column: ‘StateProvinceKey’,
Value: ’23’.
The attribute is ‘State-Province’.”
You verify that the data is accurate.You need to ensure that the dimension processes successfully.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
– Unique count of customers
– Unique count of products sold
– Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

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 indicator.
Which tab should you select? (To answer, select the appropriate tab in the work 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?