You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes reports hosted on a single SQL Server 2008 Reporting Services (SSRS) server. You plan to modify the report server infrastructure to support a scale-out deployment. You need to ensure that the scale-out deployment meets the following requirements:
-Allows users to access any of the Report Server servers by using the original Report Manager URL.
-Minimizes network traffic.

Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new SQL Server 2008 Reporting Services (SSRS) solution for an accounting department. The department currently uses Microsoft Excel 2007based reports hosted on Windows SharePoint Services (WSS) 3.0.
You need to replace the existing Excel 2007 reports with SSRS-based reports.
Your solution must meet the following requirements:
-Users must be able to access the reports by using WSS.
-Reports must be version-controlled.
-Developers must be able to deploy the reports to a WSS document library.

Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will support a Microsoft ASP.NET application that is deployed to a Web farm. Reports will be deployed to a SQL Server 2008 Reporting Services (SSRS) instance. The databases for the SSRS instance will be deployed to a two-node failover cluster that hosts a single instance of SQL Server 2008.
You need to ensure that the SSRS instance remains available even when one of the servers fails.
What should you do?

You administer a SQL Server 2000 server.
The SQL Server 2000 server hosts a SQL Server 2000 relational data warehouse and a SQL Server 2000 Analysis Services database (OLAP database).
You plan to migrate to a new SQL Server 2008 server in a new untrusted domain. You need to ensure that both the relational data warehouse and the OLAP database are migrated in the minimum possible time.
What should you do?

You administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.
The instance has the following features:
-Deployed as a single server
-Configured to use Native mode
-A custom data extension developed by using Microsoft .NET Framework 2.0

You plan to upgrade the instance to SQL Server 2008 Reporting Services. You need to upgrade the instance without loss of functionality.
What should you do?

You administer a SQL Server 2005 Reporting Services server. Your company publishes reports to a public Web site. Customers can view the reports without providing user credentials. You plan to upgrade the server to use SQL Server 2008 Reporting Services. You need to ensure that customers can continue to view the reports without providing user credentials.
What should you do?

You administer a SQL Server 2008 Reporting Services (SSRS) environment. You restore the ReportServer and ReportServerTempDB databases to a new server. When you browse to the Report Manager Web page, you receive an error message. You are unable to view the folder structure and the reports.
You need to view the folder structure and the reports.
What should you do?

You administer a server that runs SQL Server 2008 Integration Services (SSIS) packages.
The packages are stored on the file system.
You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL Server backup process.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 instance hosts a database. The database is currently scheduled for a full backup on a monthly basis.
The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. The database uses the bulk-logged recovery model.
You need to back up the database changes to a tape drive every night by using minimum storage space and time.
Which backup strategy should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 Integration Services (SSIS) developers use a SQL Server 2008 instance as the primary development environment.
All the SSIS packages contain data connection managers that use SQL Server authentication to extract data. The packages are saved by using the EncryptAllWithUserKey package protection level.You plan a package migration strategy from the development environment to a production environment. Migration will be performed by using an automated script.
You need to ensure that the packages execute without error in the production environment.
What should you do?