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.
Explanation:
A.
CLR integration is NOT required on the database engine.
D.
Events that are created by the package are NOT captured automatically during execution.
Why the same question has different answers?
In some sites it is written as “required” and in some “not required”. Even in this site, the same question repeated multiple times and each time the answer is opposite to other.
http://www.aiotestking.com/microsoft/which-of-the-following-is-true-with-regards-to-using-the-project-deployment-model-2/
Ok I got it. Sorry to make you confused.
which of the following is TRUE with regards to use the Package Deployment model:
– CLR integration IS required on the database engine.
– Events that are created by the package ARE captured automatically during execution.
Wrong Question or wrong answers.
Sorry … its correct because it says Package Deployment and not project deployment:
https://msdn.microsoft.com/en-gb/library/hh213290(v=sql.110)