You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table
includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

You develop a SQL Server Analysis Services (SSAS) stored procedure.
You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure.
What should you do?

You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including
FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate,
SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates mobile phone usage data from a Microsoft Azure SQL Database database. The
existing database contains a device dimension.
The Research and Development team has requested that capabilities be added to the database.
The capabilities must meet the following requirements:
·A device member must be able to have multiple capability members.
·A capability member must be able to belong to several device members.
·The Research and Development team must be able to create new capabilities every quarter in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

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

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is
incrementally loaded each day with approximately 800,000 new rows.

You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use?

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 in the 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 have a SQL Server Analysis Services (SSAS) database named DB1 on a server named Server1.
You need to deploy DB1 from Server1 to four other servers. If the destination server already contains a copy of DB1, the database must be updated only. If the
destination server does not contain a copy of DB1, the database must be copied to the destination server.
What is the best deployment option to use? More than one answer choice may achieve the goal.
Select the BEST answer.

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension
named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.

The Product dimension has three attribute hierarchies:
– Product
– Subcategory
– Category

The attributes have the following relationships defined: Product > Subcategory > Category. Each attribute has a key and a name sourced from the related key and
name columns in the DimProduct 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_DimProduct’, Column:
‘SubCategoryKey1, Value: “23′. The attribute is Subcategory’.”
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

You have a tabular model hosted in SQL Server Analysis Services (SSAS).
You need to add new rows to an existing table. The solution must load only the new rows to the table.
Which processing mode should you use?