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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes several SQL Server 2008 Integration Services (SSIS) packages. The SSIS packages import data from files located on other servers.
The packages will be deployed to a SQL Server 2008 instance and scheduled to run through the SQL Server Agent service. The SQL Server Agent service runs under a local user account. The SSIS packages fail to run when the SQL Server Agent jobs are executed. You need to ensure that the packages run successfully in the production environment.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Reporting Services (SSRS) instance contains a report. Employees execute the report by using Report Manager.
Each employee has his own specific set of parameters to execute the report. Data for the report is updated once daily. For each employee, the report takes more than five minutes to execute. You discover that data retrieval takes most of the time during report execution. You need to reduce the execution time of the report.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. Your solution includes relational and analysis services.
The solution has a cube that is queried by more than 650 users. During peak hours, more than 100 active connections are open on the cube at any given time. Users connect to and query the cube by using custom-built applications. You need to view the connection details and the application name that is used to connect to the cube of all users. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You deploy a SQL Server 2008 Analysis Services (SSAS) cube. The cube contains a measure group that uses table binding. The measure group contains 200 million rows. A job that processes the measure group fails. The log shows an out-of-memory error. The job uses the Process Update option.
You need to resolve the error. You need to perform this action without increasing the available physical memory for the SSAS instance. What should you do?