nerdexam
Microsoft

70-457 · Question #81

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project…

The correct answer is B. Create an Integration Services catalog. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?

Options

  • ACreate SSIS configuration files for the packages.
  • BCreate an Integration Services catalog.
  • CInstall Data Quality Services.
  • DInstall Master Data services.

How the community answered

(24 responses)
  • A
    13% (3)
  • B
    79% (19)
  • C
    4% (1)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice