You are designing a SQL Server 2008 Integration Services (SSIS) packagE.The package includes a Data
Flow task that copies several million rows. The data flow requires a match against a reference table that
contains 10,000 rows. Each row in the reference table will be used during the data flow.
You need to ensure that the data flow executes in the minimum amount of time.
Which data flow component should you select?

• A. a Lookup transformation along with the Full cache option
• B. a Fuzzy Lookup transformation
• C. a Lookup transformation along with the Partial cache option
• D. a Lookup transformation along with the No cache option

You are managing the security in SQL Server 2008 Reporting Services (SSRS).
You assign a new user to a role.
You need to grant the permissions to the user to publish reports and manage content only in a private folder.
What should you do?

• A. Assign the user to the Content Manager and the Report Builder roles.
• B. Assign the user to the Content Manager and the Browser roles.
• C. Assign the user to the Publisher role.
• D. Assign the user to the My Reports role.

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database server. The
database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager. You add the
configuration file to the package.
When the package executes, you receive an error message which indicates that login failure occurred.
You need to execute the package successfully.
What should you do?

• A. Edit the XML configuration file.
• B. Run the package on the same server as the third-party database server.
• C. Use an indirect XML configuration.
• D. Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.

You maintain SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 instance. You need to design a failure recovery plan for packages that are deployed to a SQL Server. What should you do?

• A. Back up the model database.
• B. Back up the master database.
• C. Back up the MSDB database.
• D. Back up the tempdb databse.

You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)

• A. Assign the Manage Reports task to the role.
• B. Assign the Consume Reports task to the role.
• C. Assign Set Security Policies for Items task to the role.
• D. Assign the Manage Resources task to the role.
• E. Assign the Manage All Subscriptions task to the role.