HOTSPOT
You are designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Support several packages with different configuration settings.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
Explanation:
Note:
Package Configuration Types
The following table describes the package configuration types.
* SQL Server table
A table in a SQL Server database contains the configuration. The table can include multiple
configurations.* XML configuration file
An XML file contains the configurations. The XML file can include multiple configurations.
* Environment variable
An environment variable contains the configuration.
* Registry entry
A Registry entry contains the configuration.
* Parent package variable
A variable in the package contains the configuration. This configuration type is typically used
to update properties in child packages.
Reference: Package Configurations
Why is SQL Severs the only correct answer?
I think this is the only solution that supports multiple package configuration
As far as I can see XML as the same functionality as SQL server, SQL server needs a connection manager though.
https://msdn.microsoft.com/en-us/library/cc895212.aspx
SQL Severs Correct
xml can also be a correct answer