nerdexam
Microsoft

70-463 · Question #68

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:

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.

Configure and deploy SSIS solutions

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

How the community answered

(41 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    88% (36)
  • D
    7% (3)

Why each option

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.

AOnProgress

OnProgress fires during task execution to report incremental progress and does not indicate that the task has finished.

BOnlnformation

OnInformation fires only when a task explicitly raises an informational message and is not guaranteed to fire on task completion.

COnPostExecuteCorrect

OnPostExecute is raised immediately after a task's or container's Execute method returns, regardless of success or failure. By attaching the log-write logic to this event handler on the file upload task, the OrderLog entry is guaranteed to be written as soon as the task finishes, directly satisfying the auditing policy requirement.

DOnComplete

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

Source: https://learn.microsoft.com/en-us/sql/integration-services/integration-services-ssis-event-handlers

Topics

#event handlers#OnPostExecute#auditing#logging

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice