Which two of the following options describe the solution that meets the requirements and minimizes development effort?

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 calls to the catalog.start_execution stored procedure in the
Analysis Services database start your deployment model and that performance is
maximized.
Which two of the following options describe the solution that meets the requirements and
minimizes development effort? (Choose two).

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 calls to the catalog.start_execution stored procedure in the
Analysis Services database start your deployment model and that performance is
maximized.
Which two of the following options describe the solution that meets the requirements and
minimizes development effort? (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.
Select the SQL Server Package Configuration option and modify the SSIS Configurations table
before executing the package.

Explanation:



Leave a Reply 1

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


Mahmoud Ibrahim

Mahmoud Ibrahim

B, D