Which of the following is TRUE with regards to using th…

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 received reports regarding a current existing SQL Server Integration Services (SSIS) package not
completing its execution, and not transferring data. You have decided to make use of the Package Deployment
Model.
Which of the following is TRUE with regards to using the Package Deployment Model?

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 received reports regarding a current existing SQL Server Integration Services (SSIS) package not
completing its execution, and not transferring data. You have decided to make use of the Package Deployment
Model.
Which of the following is TRUE with regards to using the Package Deployment Model?

A.
CLR integration is NOT required on the database engine.

B.
Environment-specific parameter values are stored in environment variables.

C.
Events that are created by the package are captured automatically and saved to the catalog during
execution.

D.
Events that are created by the package are NOT captured automatically during execution.



Leave a Reply 2

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