Microsoft
70-463 · Question #125
70-463 Question #125: Real Exam Question with Answer & Explanation
The correct answer is D: The OnPostValidate event handler.. The OnPostValidate event handler fires after an executable completes its validation phase, making it the correct handler when the requirement is to raise an event upon completion of verification.
Question
You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured upload a file to a table in a SQL Azure database. You need to make sure that the code includes an event handler that makes use of an executable to raise the event when its verification is completed. Which of the following is the event handler that you should use?
Options
- AThe OnPostExecute event handler.
- BThe OnTaskFailed event handler.
- CThe OnPreExecute event handler.
- DThe OnPostValidate event handler.
Explanation
The OnPostValidate event handler fires after an executable completes its validation phase, making it the correct handler when the requirement is to raise an event upon completion of verification.
Common mistakes.
- A. OnPostExecute fires after the executable completes its execution phase, not after the validation/verification phase.
- B. OnTaskFailed fires when a task encounters a failure during execution, which is unrelated to the completion of the validation phase.
- C. OnPreExecute fires immediately before an executable begins its execution phase, not after validation is completed.
Concept tested. SSIS OnPostValidate event handler - post-validation lifecycle event
Reference. https://learn.microsoft.com/en-us/sql/integration-services/integration-services-ssis-event-handlers
Community Discussion
No community discussion yet for this question.