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

Hot Area:

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.)
Select and Place:

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.)
Select and Place:

You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure
SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to
another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the
answer area.)
Hot Area:

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL
Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on
the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.
Hot Area:

You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be
applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations
section of the Sales cube.

Which statement fragments should you use? (To answer, drag the appropriate statement
component to the correct location or locations in the answer area. Use only components that
apply.)
Select and Place:

You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of values
for France and Germany.
Which expression should you use? (To answer, drag the appropriate expression to the answer
area.)
Select and Place:

You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services
(SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product
Categories hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate
functions from the list of functions to the correct locations in the answer area.)
Select and Place:

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 measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)
Hot Area:

You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to
currency exchange rates. One of the measures in this group is named Average Rate and it will be
used to report the average currency exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange
rate over time.
Which value should you select for the AggregationFunction property for the Average Rate
measure? To answer, select the appropriate setting in the answer area.

Hot Area: