nerdexam
Microsoft

70-463 · Question #236

You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source a

The correct answer is C. Implement project connection managers.. Project connection managers in the SSIS Project Deployment Model are defined once at the project level and shared automatically across all packages, minimizing duplicate configuration effort.

Configure and deploy SSIS solutions

Question

You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source and destination. You need to define and reuse the connection managers in all the packages by using the least development effort. What should you do?

Options

  • AImplement parent package variables.
  • BCopy and paste connection managers from one package to the others.
  • CImplement project connection managers.
  • DImplement package connection managers.

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    6% (2)
  • C
    83% (30)
  • D
    3% (1)

Why each option

Project connection managers in the SSIS Project Deployment Model are defined once at the project level and shared automatically across all packages, minimizing duplicate configuration effort.

AImplement parent package variables.

Parent package variables require a parent-child package execution pattern where a parent package passes values to child packages via Execute Package tasks, which adds architectural complexity rather than reducing effort.

BCopy and paste connection managers from one package to the others.

Copying and pasting connection managers into each of the 10 packages creates 10 separate copies that must each be maintained individually, which is the opposite of minimizing development effort.

CImplement project connection managers.Correct

Project connection managers are a feature of the Project Deployment Model that allows a single connection manager to be defined at the project level and reused by all packages within that project, eliminating the need to configure the same connection in each of the 10 packages individually.

DImplement package connection managers.

Package connection managers are scoped to a single package and must be created and configured separately in each package, requiring the same work to be repeated 10 times.

Concept tested: SSIS Project Deployment Model project-level connection managers

Source: https://learn.microsoft.com/en-us/sql/integration-services/connection-manager/integration-services-ssis-connections

Topics

#project connection managers#project deployment model#connection reuse#SSIS project

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice