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

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

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 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 managing a SQL Server Reporting Services (SSRS) instance in native mode.
A role named Folder Access Controller is present onthe 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 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 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 developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance,
sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use.
The sales team does not need any information other than sales-related resources in the tabular model.
The finance and marketing teams need to see all theresources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and
administrative effort.
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
– Minimum Sales Price
The Minimum Sales Price column is available only inthe Products table.
You add a column named Is Undersell to the Invoice Line Items table.
The Is Undersell column must store a value of TRUE if the value of the Unit Sales Price is less than the value
of the Minimum Sales Price.
Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Undersell column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)