nerdexam
Microsoft

70-450 · Question #78

70-450 Question #78: Real Exam Question with Answer & Explanation

Sign in or unlock 70-450 to reveal the answer and full explanation for question #78. The question stem and answer options stay visible for context.

Question

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. 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?

Exhibit

70-450 question #78 exhibit

Options

  • ATo achieve the goal, the Import and Export Wizard should be utilized to save packages.
  • BTo achieve the goal, a direct package configuration should be created for each package.
  • CTo achieve the goal, a deployment utility should be created for the SSIS project.
  • DTo achieve the goal, an indirect package configuration should be created for all packages.

Unlock 70-450 to see the answer

You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-450 Practice