You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote
users.
These users have no access to the report server.
You need to ensure that the application renders the report correctly.
What should you do?

You design a report by using SQL Server 2008 Reporting Services (SSRS).
Detail information is displayed each time the users render the report.
You need to ensure that the following requirements are met:
Summary information is displayed when the report is initially rendered.
Detail information is displayed only when the users click a column header.
What should you do?

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a
parameter named Category that is used to filter a list of products. The list uses a dataset that
contains the following query:

You modify the report parameter to allow multiple values. You need to modify the report to
help search for multiple Category values by using minimum amount of development effort.
What should you do?

You are developing a SQL Server 2008 Integration Services (SSIS) project in Business
Intelligence Development Studio.
You configure the project properties as shown in the following image.

You need to create a deployment manifest for all packages in the project.
What should you do?

You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server
2008.
You use a development server named SQL_DEV1. There is no network connectivity
between the development server and the production server.
You deploy the package to the SQL_PROD1 server.
The package fails to execute. The error message states that the package cannot connect to
the SQL_DEV1 server.
You need to modify the package to refer to the SQL_PROD1 server when being executed.
What should you do?

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loopcontainer.
Imports the contents of the files to a table by using a Data Flowtask.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute
within a single transaction.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You design a package by using SQL Server 2008 Integration Services (SSIS). The package
is designed by using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the
local SQL Server 2008 instance. You deploy the package to the MSDB database on the
production server.
You need to ensure that only users that belong to an appropriate database role can modify
and execute the deployed package. You also need to ensure that these users cannot access
other packages that are deployed to the server.
What should you do?

You develop a package by using SQL Server 2008 Integration Services (SSIS).
You use a local instance of SSIS to develop and test the package.
The package uses an XML configuration file that contains a connection string. The
connection string includes a user name and a password to connect to the source data.
You deploy the package to the production server. You discover that validation errors occur
when the package is being executed.
You need to ensure that the package executes successfully in the production environment.
What should you do?

You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover
cluster. You have a complex package that takes a long time to run. You need to ensure that
if the package executes during a failover, the package can be resumed at the point of failure.
What should you do?

You develop a SQL Server 2008 Integration Services (SSIS) package.
The package downloads several files from a remote FTP server by using multiple FTP tasks,
and then processes data by using multiple Execute SQL tasks.
You need to configure the package to restart at the point of failure after the package
downloads the files.
What should you do?