You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning.
The cube consists of two measure groups named Sales and Planning. Each measure group
is based on a data warehouse fact table and consists of a single MOLAP partition that has
the same name as its measure group.
The Planning measure group consists of two measures:
Forecast, which uses the Sum aggregate function
Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load
(ETL) process is scheduled to periodically transfer the planning values from the database of
the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are
sometimes out of date. A new company requirement mandates that the planning values be
entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

You are developing a BI Semantic Model (BISM) that retrieves data from several sources
including a Microsoft Azure SQL Database database and an OData data feed. The model
will be deployed to a server with significantly more memory than the total size of the source
data.
You have the data feed URL, which you will use when developing the model in SQL Server
Data Tools (SSDT).
The model must meet the following requirements:
Maximize performance
Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
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) 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.)

You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key
attribute.
The underlying data of the Customer Geography dimension supports relationships between
attributes.
You need to increase query and dimension processing performance.

What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data
from a Microsoft Azure SQL Database database. The existing database contains a customer
dimension.
The marketing team has requested that customer marketing categories be added to the
database.
The marketing categories must meet the following requirements:
A customer member must be able to belong to multiple category members.
A category member must be able to group several customer members.
The marketing team must be able to create new categories every month 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.)

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

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

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An
item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can view and modify report caching parameters.
Which task should you add to the Developer role?

You manage a SQL Server Reporting Services (SSRS) instance. The
ReportingServicesService.exe.config file has been modified to enable logging.
Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the
server.
What should you do?