70-463 · Question #128
70-463 Question #128: Real Exam Question with Answer & Explanation
The correct answer is A: CLR integration is required on the database engine.. 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
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.
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.
Community Discussion
No community discussion yet for this question.