Which of the following suitably describes an Environment Variable?

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 IntegrationServices (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 deployedpackages are executed using any of the specified
Environments.
Which of the following suitably describes an Environment Variable?

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 IntegrationServices (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 deployedpackages 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 foldersto organize your projects and environments.

E.
An environment variable is a container of variables that can be referenced by Integration Services projects.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Howie

Howie

C.
An environment variable defines a literal value that can be assigned to a parameter during package
execution.