Microsoft Exam Questions

Which of the five package configuration options should you use?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.

A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages. You need
to select a package configuration option that will allow you to store multiple configuration
properties/values and support encryption using EFS (Encrypted File System).
Which of the five package configuration options should you use?

A.
XML Configuration File

B.
Environment Variable

C.
Registry Entry

D.
Parent Package Variable

E.
SQL Server

Explanation: