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…

Question

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.

• A
  73% (33)
• B
  7% (3)
• D
  20% (9)

Explanation

Two statements are true about the Project Deployment Model: (A) CLR integration IS required on the SQL Server database engine because the SSISDB catalog relies on CLR stored procedures and functions to manage package execution and logging. Without CLR enabled, the catalog cannot function. (C) Events generated by packages are automatically captured and saved to the SSISDB catalog without any additional configuration, enabling built-in operational reporting. Statement B is false because CLR is required, not optional. Statement D is false because the Project Deployment Model executes packages through the SSISDB catalog using T-SQL (catalog.start_execution), not dtExec/DTExecUI directly.

No community discussion yet for this question.