nerdexam
Microsoft

70-463 · Question #119

You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to import data into a SQL Azure hosted data warehouse. You have decided to make use

The correct answer is A. It stores the property path inside the package and the value outside the package.. The Environment Variable package configuration type in legacy SSIS stores the property path within the package itself but retrieves the actual value from an operating system environment variable at runtime.

Configure and deploy SSIS solutions

Question

You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to import data into a SQL Azure hosted data warehouse. You have decided to make use of the Environment Variable package configuration as part of your solution. Which of the following is TRUE with regards to the Environment Variable package configuration?

Options

  • AIt stores the property path inside the package and the value outside the package.
  • BIt stores both the property path and the value outside the package.
  • CIt is used to fetch a value from a variable in a calling package.
  • DIt is the most commonly used configuration type.

How the community answered

(19 responses)
  • A
    89% (17)
  • C
    5% (1)
  • D
    5% (1)

Why each option

The Environment Variable package configuration type in legacy SSIS stores the property path within the package itself but retrieves the actual value from an operating system environment variable at runtime.

AIt stores the property path inside the package and the value outside the package.Correct

With Environment Variable configuration, the package stores the property path (which package property to configure) internally, while the value that populates that property is read from an OS-level environment variable at runtime. This separates the configuration target from the configuration value, enabling environment-specific deployments.

BIt stores both the property path and the value outside the package.

Storing both the property path and value outside the package describes the XML configuration file type, not the Environment Variable configuration type.

CIt is used to fetch a value from a variable in a calling package.

Fetching a value from a variable in a calling package describes the Parent Package Variable configuration type.

DIt is the most commonly used configuration type.

The XML configuration file is considered the most commonly used configuration type in the legacy Package Deployment Model, not the Environment Variable type.

Concept tested: SSIS Environment Variable package configuration type behavior

Source: https://learn.microsoft.com/en-us/sql/integration-services/packages/package-configurations

Topics

#package configuration#Environment Variable configuration#property path#configuration types

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice