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

DRAG DROP
You have a cube named Cube1 that contains the sales data for your company.
You plan to build a report based on the cube.
You need to write an MDX expression that returns the total sales from the first month of the
2009 fiscal year and the total sales from the same period of the 2008 fiscal year.
Which code segments should you insert at line 03 and line 05? To answer, drag the
appropriate code segments to the correct lines. Each code segments may be used once,
more than once, or not at all. You may need to drag the split bar between panes or scroll to
view content.

HOTSPOT
A sales cube contains two years of data.
The sales team must see year-over-year (YOY) and month-over-month (MOM) sales
metrics.
You need to modify the cube to support the sales team’s requirements.
Which Business Intelligence Wizard enhancements should you use? (To answer, configure
the appropriate option or options in the dialog box in the answer area.)

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 are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant permission for salespersons to be able to view only the data based on
their sales territory.
What should you do?

You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has
SQL Server Analysis Services (SSAS) installed. The model uses a relational data source
named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the
model to DB1.
What should you do?

HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows
Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or
show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate
tab in the answer area.)

DRAG DROP

You are developing a SQL Server Reporting Services (SSRS) report to display a list of
employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page
of the company intranet site.
The report consists of a single table. The design of the table is shown in the following diagram.

You need to configure the EmailAddress detail text box to create a new email message. The
email message must be addressed to the email address that was clicked by the user.
Which four 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.)