DRAG DROP

You administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are
provisioned.
You need to monitor the number of report data feed processing events during every
automated 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.)

You are designing a reporting solution that uses SQL Server Reporting Services (SSRS) in
SharePoint integrated mode.
The reporting solution must meet the following requirements:
Allow report writers to reuse content between different reports.
Allow report writers to modify reusable content in SharePoint.
Retain version history for report content.
You need to choose a reporting method that meets the requirements.
What should you use? (More than one answer choice may achieve the goal. Select the
BEST answer.)

DRAG DROP
You are administering a SQL Server Analysis Services (SSAS) database on a server. The
database hosts a financial cube based on a SQL Azure database.
You need to grant read access to the financial cube for all users in the group
USA\PowerUsers.
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.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS
catalog to the disaster recovery server.
Which three steps should you document 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 deploy a PowerPivot workbook to a document library in a Microsoft SharePoint site.
Workbook data comes from two different sources: Source A and Source B.

The workbook contains three small lookup tables from Source A, and five tables with a total
of 20 million rows from Source B. Data from Source A is updated at 9:00 A.M. and data from
Source B is updated throughout the day.
You have the following requirements:
Refresh the PowerPivot workbook with updated lookup data as soon as possible.
Minimize load on the source systems and the SharePoint environment during business
hours.
Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You need to design a data warehouse schema to support a multidimensional cube. The fact
table will contain multiple columns representing order dates, shipping dates, and billing
dates. The cube will contain a measure group based on the fact table.
What is the best design to achieve the goal? More than one answer choice may achieve the
goal. Select the BEST answer.

You are creating a product dimension table and a SQL Server Integration Services (SSIS)
package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.

HOTSPOT
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube.
You need to ensure that every aggregation includes the Category attribute.
Which option should you select? To answer, select the appropriate option button in the
answer area.

DRAG DROP
You are designing a business intelligence (BI) solution for a hotel booking system. Each
hotel booking may have more than one guest.
The BI solution contains a fact table named Booking, a factless fact table named
Booking_Guest and a dimension named Guest.
Booking contains an entry for each booking. Booking_Guest contains an entry for each
guest in each booking. Guest contains an entry for each guest.
You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS)
for the hotel booking system.
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 redesigning a SQL Server Analysis Services (SSAS) database that contains a cube
named Sales. Before the initial deployment of the cube, partition design was optimized for
processing time. The cube currently includes five partitions named FactSalesl through
FactSales5. Each partition contains from 1 million to 2 million rows.

The FactSales5 partition contains the current year’s information. The other partitions contain
information from prior years; one year per partition. Currently, no aggregations are defined
on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source
and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query
performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)