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 Project Deployment Model.
Which of the following is TRUE with regards to using the Project Deployment Model?
A.
CLR integration is required on the database engine.
B.
CLR integration is not required on the database engine.
C.
Events that are created by the package are captured automatically and saved to the catalog
during execution.
D.
Packages are executed using the dtExec and DTExecUI execution utilities.
Explanation: