nerdexam
Microsoft

70-463 · Question #17

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog. You need to add the Environment to the project.

The correct answer is C. catalog.create_environment_reference. Linking an existing SSIS catalog Environment to a project requires creating an environment reference that associates the project with that Environment. The catalog.create_environment_reference stored procedure performs this association.

Configure and deploy SSIS solutions

Question

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog. You need to add the Environment to the project. Which stored procedure should you use?

Options

  • Acatalog.set_environment_reference_type
  • Bcatalog.set_environment_property
  • Ccatalog.create_environment_reference
  • Dcatalog.create_environment

How the community answered

(40 responses)
  • A
    5% (2)
  • C
    93% (37)
  • D
    3% (1)

Why each option

Linking an existing SSIS catalog Environment to a project requires creating an environment reference that associates the project with that Environment. The catalog.create_environment_reference stored procedure performs this association.

Acatalog.set_environment_reference_type

catalog.set_environment_reference_type modifies the type (relative or absolute) of an environment reference that already exists; it cannot create a new reference.

Bcatalog.set_environment_property

catalog.set_environment_property sets a property such as the description of an Environment object itself, and does not associate an Environment with a project.

Ccatalog.create_environment_referenceCorrect

catalog.create_environment_reference creates a reference between a deployed SSIS project and an Environment in the SSISDB catalog, which is the required step to make the Environment's variables available for mapping to project or package parameters.

Dcatalog.create_environment

catalog.create_environment creates a brand-new Environment folder object in the catalog; since the Environment already exists, this procedure is not needed and would not link it to the project.

Concept tested: SSIS catalog environment reference creation for project association

Source: https://learn.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-create-environment-reference-ssisdb-database

Topics

#SSIS catalog#environment reference#catalog stored procedures#Project Deployment Model

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice