You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure which includes SQL Server
Integration Services (SSIS).
You need to create a project in SSIS that will contain multiple SSIS packages.
The variables and connection managers will be the same for all SSIS packages within the
project. You need to parameterize the connection manager strings to enable the properties
to be updated for subsequent package runs.
You need to ensure that your solution includes the automatic logging of events in the
Analysis Services database.
Which two of the following options describe the solution that meets the requirements and
maximizes performance? (Choose two).
A.
Your solution should use the package deployment model.
B.
Your solution should use the project deployment model.
C.
Configure the connection manager properties to use package parameters.
D.
Configure the connection manager properties to use project parameters.
E.
Create an XML file each SQL Server environment with the connection configuration settings
and reference the file using a variable.
Explanation:
ok