PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the application developers can deploy the project successfully to the production serve

You administer a SQL Server 2008 instance for your company. Your company has a team
of database administrators. A team of application developers create SQL Server 2008
Integration Services (SSIS) packages on the test server in a shared project. One of the
packages requires a fixed cache file. On completion of development, the packages will be
deployed to the production server. Only the database administrators can access the
production server. You need to ensure that the application developers can deploy the
project successfully to the production server. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the Import and Export Wizard to save packages.

B.
Create a deployment utility for the SSIS project.

C.
Create a direct package configuration for each package.

D.
Create an indirect package configuration for all packages.

Explanation:


Leave a Reply