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?

DRAG DROP
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are
planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

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

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

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The
project file includes two cubes named Finance and Operations. The project also includes a
dimension named Date. The Date dimension includes two hierarchies named Fiscal and
Calendar. The Date dimension has been added to both cubes.
You need to disable the Fiscal hierarchy in the Operations cube without impacting other
database objects.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You create a degenerate dimension.
You need to define a relationship type for the dimension.
Which relationship type should you select? (To answer, configure the appropriate option or
options in the dialog box in the answer area.)

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?

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