Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain the SQL Server 2008 Integration Services (SSIS) instances for a an insurance company.
You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. The package is configured externally to the file Mamberinformationconfig.cfg.
You need to execute the package.
Which command syntax should you use?

• A. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
• B. dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
• C. dtexec /f " Z:\ Memberinformation.dtsx " /conf "
  Z: \Memberinformationconfig,cfg "
• D. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
• E. dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
• F. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
• G. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
• H. dtexec /sq Memberinformation /ser productionServer / va

You create a SQL Server 2008 Reporting Services (SSRS) report. This report includes a matrix containing three groups. The last group is Customer Name.
When a user clicks on a customer name, a new report should open with detailed customer information.
You need to enable this functionality. What option should you use?

• A. Go to Bookmark
• B. Enable Interactive Sorting
• C. Go to URL
• D. Go to Report

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server. The
database contains a cube.
You add new functionality to the cube on a development server.
You need to deploy the new functionality from the development server to the production server by ensuring
that the effect on the users is minimized.
What should you do?

• A. Copy the appropriate files from the development server to the production server.
• B. Modify the Target Server property to the production server by using Business Intelligence Development Studio (BIDS). Deploy the solution.
• C. Use the Synchronize Database Wizard.
• D. Detach the production database. Copy the appropriate files to the production server, and then attach the database on the production server.

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by
using your local development environment.
The package is deployed to a production server.
You need to configure the protection level of the package to ensure that only the user who deployed the
package can execute it.
Which protection level should you use?

• A. DontSaveSensitive
• B. EncryptSensitiveWithPassword
• C. EncryptAllWithUserKey
• D. EncryptAllWithPassword

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. Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.
• C. Use an indirect XML configuration.
• D. Run the package on the same server as the third-party database server.