You are developing reports based on the SQL Server Analysis Services (SSAS) cube named
Orders.
A Multidimensional Expressions (MDX) query must include a query-scoped calculated member, which
computes average sales per order item.
The query must also return the set of three states in a query-scoped named set named East Coast Customers.
You need to define the calculations in an MDX queryto meet the requirements.
Which four MDX segments should you insert in sequence before a SELECT statement?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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.)

You are developing a SQL Server Analysis Services (SSAS) cube.
The cube consists of a single measure group.
The measure group consists of one partition that uses MOLAP.
The proactive caching policy has the following requirements:
– The cache must be updated when data is changed inthe table named tblOrders.
– Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command.
You need to configure the proactive caching policy to meet the requirements.
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.)

You are using Multidimensional Expressions (MDX) toquery a SQL Server Analysis Services (SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered products 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 thelist of functions to the correct locations in the answer 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.)

You manage a SQL Server Reporting Services (SSRS) instance in native mode.
You are building a shared dataset for your weekly performance reports.
The shared dataset uses a data source that is configured to use credentials that are stored in the Report
Server.
You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS.
You need to enable caching on the shared dataset.
You also need to use an existing shared schedule todiscard the cache.
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.)

You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database.
The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table.
The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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.)

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to
source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously.
You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server
to process data contained within the partition.
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.)

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to
source data from a SQL Azure database.
The cube is processed each night at midnight.
The largest partition in the cube takes 12 hours toprocess, and users are unable to access the cube until
noon.
The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to
satisfy the query.
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.)

You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are frequently executed.
You discover that the report server execution logs are empty, despite significant report activity.
You need to ensure that the server is configured for report execution logging.
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.)