70-463 · Question #116
You have recently created an SQL Server Integration Services (SSIS) project catalog that contains two Environments. A single Environment Variable, named ConnectionString, of type string is specified…
The correct answer is C. An environment variable defines a literal value that can be assigned to a parameter during. SSIS Environment Variables in the catalog are used to define literal values that can be assigned to package or project parameters at execution time, keeping values configurable without modifying the package itself.
Question
You have recently created an SQL Server Integration Services (SSIS) project catalog that contains two Environments. A single Environment Variable, named ConnectionString, of type string is specified by each environment. The project also has a project Connection Manager configured to link up with the data warehouse. You have been instructed to make sure that deployed packages are executed using any of the specified Environments. Which of the following suitably describes an Environment Variable?
Options
- AAn environment variable specifies the data that will be used by a package.
- BAn environment variable can be used to manage Integration Services objects in the catalog.
- CAn environment variable defines a literal value that can be assigned to a parameter during
- DAn environment variable allows you to use folders to organize your projects and
- EAn environment variable is a container of variables that can be referenced by Integration
How the community answered
(27 responses)- A7% (2)
- C89% (24)
- E4% (1)
Why each option
SSIS Environment Variables in the catalog are used to define literal values that can be assigned to package or project parameters at execution time, keeping values configurable without modifying the package itself.
This confusingly describes a parameter or data source, not an environment variable - environment variables hold configuration values, not the actual data processed by the package.
Managing Integration Services objects in the catalog is the role of catalog-level operations and roles, not environment variables.
An Environment Variable in the SSIS catalog stores a literal value (such as a connection string) that can be mapped to a project or package parameter at runtime. This allows the same deployed package to run against different environments by referencing different Environment Variables, which is precisely the use case described - executing packages using any of the specified Environments.
Using folders to organize projects and packages describes the catalog folder structure, not environment variables.
A container of variables that can be referenced by Integration Services describes an Environment object, not an individual Environment Variable.
Concept tested: SSIS catalog Environment Variable definition and purpose
Source: https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog
Topics
Community Discussion
No community discussion yet for this question.