nerdexam
Microsoft

70-457 · Question #191

70-457 Question #191: Real Exam Question with Answer & Explanation

The correct answer is A. CLR integration is required on the database engine. C. Events that are created by the package are captured automatically and saved to the catalog. See the full explanation below for the reasoning.

Question

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?

Options

  • ACLR integration is required on the database engine.
  • BCLR integration is not required on the database engine.
  • CEvents that are created by the package are captured automatically and saved to the catalog
  • DPackages are executed using the dtExec and DTExecUI execution utilities.

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice