Microsoft
70-463 · Question #24
70-463 Question #24: Real Exam Question with Answer & Explanation
The correct answer is A: OnPostExecute. The OnPostExecute event handler fires immediately after a task finishes executing, making it the correct choice for writing an audit log entry as soon as the upload task completes.
Question
You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company's auditing policies have the following requirements: - An entry must be written to a dedicated SQL Server log table named OrderLog. - The entry must be written as soon as the file upload task completes. You need to meet the company's policy requirements. Which event handler should you use?
Options
- AOnPostExecute
- BOnWarning
- COnExecStatusChanged
- DOnVariableValueChanged
Explanation
The OnPostExecute event handler fires immediately after a task finishes executing, making it the correct choice for writing an audit log entry as soon as the upload task completes.
Common mistakes.
- B. OnWarning fires only when a warning is issued during execution, not when a task completes normally, so it would not reliably capture every upload completion.
- C. OnExecStatusChanged fires when the execution status of a task changes at a lower level and is not intended for post-completion audit logging workflows.
- D. OnVariableValueChanged fires when a variable's value is modified, which is unrelated to task completion and would not trigger on upload task completion.
Concept tested. SSIS event handler selection for post-task audit logging
Reference. https://learn.microsoft.com/en-us/sql/integration-services/integration-services-ssis-event-handlers
Community Discussion
No community discussion yet for this question.