You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
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?
A.
An environment variable specifies the data that will be used by a package.
B.
An environment variable can be used to manage Integration Services objects in the catalog.
C.
An environment variable defines a literal value that can be assigned to a parameter during
package execution.
D.
An environment variable allows you to use folders to organize your projects and environments.
E.
An environment variable is a container of variables that can be referenced by Integration
Services projects.
Explanation: