You are designing a subscription strategy for a SQL Server Reporting Services (SSRS)
report.
You have an application that populates a table with user-specific subscription schedules and
report formats.
You need to ensure that users can receive reports by email according to their preferences.
Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

DRAG DROP
You are configuring an Excel Services service application in a Microsoft SharePoint farm.
Users will deploy Excel workbooks to SharePoint libraries that allow interaction with
PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server
Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.
You need to ensure that users can refresh the PivotTables from within Excel Services
without a warning message appearing.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the
answer area. (Use only terms that apply.)

A hospital has a relational data warehouse, a SQL Server Analysis Services (SSAS)
database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database
contains a cube named Pharmacy. Shared data sources exist in SSRS for the relational and
SSAS databases. Each hospital department has its own report writers.
Report writers in the Human Resources (HR) department want to create new reports by
using Report Builder. Many reports will include data generated by a custom formula that
references data stored either in a data warehouse table or in the Pharmacy cube. The
custom formula will compare time periods across multiple products, categories, and
employees.
You have the following requirements:
Ensure that only the HR department report writers can access the custom formula.
Implement only one dataset.
Ensure that the dataset references the data source that will provide the fastest data retrieval.

You need to meet the requirements to support the HR department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

HOTSPOT
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on the results of a currency exchange SOAP web service call.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.

Your network contains the following components:
Microsoft SharePoint Server 2010
SQL Server 2008 Service Pack 2 (SP2)
SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode
You need to recommend a solution to upgrade the network to SQL Server 2014.
The solution must meet the following requirements:
Minimize the amount of time that SharePoint services are unavailable.
Deploy the upgraded Reporting Services instance in Reporting Services SharePoint
Integrated Mode.
You upgrade the Database Engine to SQL Server 2014.
Which three actions should you recommend performing next? Each correct answer presents
part of the solution.

DRAG DROP
Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each
report has several datasets defined with complex Multidimensional Expressions (MDX)
queries. The company maintains separate development, test and production environments.
The reports are running slowly. You plan to analyze report performance. You have the
following requirements:
Monitor query statistics on the production server with as little server overhead as possible.
Gather, replay, and analyze statistics on the test server with as little administrative effort as
possible.
Identify the longest-running queries on both servers.
Document statistics on disk reads on both servers.
You need to gather statistics and meet the requirements.
Which features should you use?
To answer, drag the appropriate feature or features to the correct location or locations in the
answer area. (Use only features that apply.)

DRAG DROP
You have a business intelligence (BI) solution that uses SQL Server Integration Services
(SSIS). The BI solution includes an extract transformation, and load (ETL) system.
You are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow path
for each package execution.
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.

DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have
access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day.
The server used for disaster recovery has an operational SSIS catalog.
The production server that hosts the SSISDB database fails.
Sensitive data that is encrypted in the SSISDB database must not be lost.
You need to restore the production SSIS catalog to the disaster recovery server.
Which three steps 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.

HOTSPOT
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular
database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.

You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a
Microsoft SharePoint 2010 farm.
You need to upgrade to SSRS 2014 with the minimum downtime and hardware
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)