Microsoft
70-463 · Question #68
70-463 Question #68: Real Exam Question with Answer & Explanation
The correct answer is C: OnPostExecute. The OnPostExecute event handler fires immediately after a task finishes executing, making it the correct choice to write an audit log entry as soon as the file upload task completes.
Question
You are designing a SQL Server Integration Services (SS1S) 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
- AOnProgress
- BOnlnformation
- COnPostExecute
- DOnComplete
Explanation
The OnPostExecute event handler fires immediately after a task finishes executing, making it the correct choice to write an audit log entry as soon as the file upload task completes.
Common mistakes.
- A. OnProgress fires during task execution to report incremental progress and does not indicate that the task has finished.
- B. OnInformation fires only when a task explicitly raises an informational message and is not guaranteed to fire on task completion.
- D. OnComplete is not a standard SSIS event handler; the correct event for capturing the moment after task execution ends is OnPostExecute.
Concept tested. SSIS OnPostExecute event handler 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.