nerdexam
Microsoft

70-460 · Question #6

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading. The production environment includes…

The correct answer is C. Use a package deployment model. See the full explanation below for the reasoning.

Question

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading. The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility. You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • AUse a project deployment model.
  • BUse a package deployment model.
  • CUse a package deployment model.
  • DUse a project deployment model.

How the community answered

(45 responses)
  • A
    4% (2)
  • B
    4% (2)
  • C
    80% (36)
  • D
    11% (5)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice