70-463 · Question #169
70-463 Question #169: Real Exam Question with Answer & Explanation
The correct answer is A: Add OnError and OnWarning event handlers.. In SSIS, when execution trees encounter errors or warnings without dedicated event handlers, the runtime may throttle or serialize subsequent trees to avoid cascading failures, effectively limiting parallelism. Adding OnError and OnWarning event handlers at the package or task le
Question
Options
- AAdd OnError and OnWarning event handlers.
- BCreate a new project and add the package to the project.
- CQuery the ExecutionLog table.
- DAdd an Execute SQL task to the event handlers.
Explanation
In SSIS, when execution trees encounter errors or warnings without dedicated event handlers, the runtime may throttle or serialize subsequent trees to avoid cascading failures, effectively limiting parallelism. Adding OnError and OnWarning event handlers at the package or task level gives the SSIS engine a defined path for handling error conditions per execution tree. This allows the engine to isolate faults within individual trees rather than halting or delaying others, enabling all 10 trees to execute concurrently. Without such handlers, the runtime's default behavior can constrain parallelism to protect execution integrity - in this scenario, that manifests as a cap of five concurrent trees.
Community Discussion
No community discussion yet for this question.