You plan to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008
failover cluster. Internet Information Services (IIS) is installed on both nodes of the cluster.
The IIS is virtualized on the Network Load Balancing (NLB) cluster. You need to deploy
SSRS in a fault tolerant scale-out deployment. What should you do?

You maintain a SQL Server 2008 Reporting Services (SSRS) database server.
The instance contains a large number of reports that take a long time to execute. The
reports contain multiple execution snapshots.
You have a new production server along with SSRS installed.
You need to migrate the reports and their snapshots to the production server in the minimum
amount of time.
What should you do?

You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server
contains a folder named Management Reports.
All groups can view and modify reports in any folder.
You need to ensure that only the Managers group can view and modify reports in the
Management Reports folder.
What should you do?

You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
A developer accidentally deploys 1000 reports to the SSRS instance.
You need to restore the SSRS instance to its original state.
Which database should you restore?

You create a report by using SQL Server 2008 Reporting Services (SSRS).

You plan to deploy the report on a report server. The report will be delivered on a regular
basis to a dynamic list of subscribers.
You need to create a new subscription on the report server.
What should you do?

You create a report by using SQL Server 2008 Reporting Services (SSRS).
The report is complex and takes several minutes to generate.
You need to configure the report server to cache the report for 30 minutes after the initial
request.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named
Orders that contains the following columns:
• OrderKey
• Shipper
• OrderAmount
You create a dimension named DimOrders from the Orders table. You set the OrderKey as a
key column and the Shipper column as an attribute. You create a measure group named
FactOrders from the Orders table.
You need to create a dimension relationship to ensure that the OrderAmount column can be
aggregated by the Shipper column.

What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as
shown in the following exhibit. (Click the Exhibit button.)

You need to ensure that the Amount measure can be aggregated for the DimCustomer
dimension.
What should you do?

You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining
extensions (DMX) to query a data mining model. You write the following DMX code segment
to query a Bike Buyer data mining model in a Decision Tree data mining structure. (Line
numbers are included for reference only.)

You need to ensure that the input columns automatically map to the columns in the data
mining structure.
Which code fragment should you insert at line 05?

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key
performance indicator (KPI) named GPMargin for your solution. You set the Value
expression of the KPI in the following manner.

You need to set a Trend expression of the KPI to show a difference in the values compared
with the previous quarter. Which MDX code segment should you insert at line 02?