PrepAway - Latest Free Exam Questions & Answers

Which action will you perform to achieve the goal?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance of your company is managed by you.
There is a team of database administrators in your company.
SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application
developers. A fixed cache file is required by one of the packages.
The company will deploy the packages to the production server on completion of development.
The production server is available only to the database administrators. Since you are the technical support,
you need to confirm that the project can be deployed successfully to the production server by the application developers.
Which action will you perform to achieve the goal?

PrepAway - Latest Free Exam Questions & Answers

A.
To achieve the goal, the Import and Export Wizard should be utilized to save packages.

B.
To achieve the goal, a direct package configuration should be created for each package.

C.
To achieve the goal, a deployment utility should be created for the SSIS project.

D.
To achieve the goal, an indirect package configuration should be created for all packages.


Leave a Reply