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

You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure
database and a SQL Server Analysis Services (SSAS) cube.
The cube contains a date dimension and other dimensions.
The report design includes two report parameters named StartDate and FinishDate as shown in the following
diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube.
You also need to ensure that the dataset is filtered by the existing report parameters.
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 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.)