nerdexam
Microsoft

70-463 · Question #125

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…

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.

Configure and deploy SSIS solutions

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.

How the community answered

(35 responses)
  • A
    3% (1)
  • C
    3% (1)
  • D
    94% (33)

Why each option

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.

AThe OnPostExecute event handler.

OnPostExecute fires after the executable completes its execution phase, not after the validation/verification phase.

BThe OnTaskFailed event handler.

OnTaskFailed fires when a task encounters a failure during execution, which is unrelated to the completion of the validation phase.

CThe OnPreExecute event handler.

OnPreExecute fires immediately before an executable begins its execution phase, not after validation is completed.

DThe OnPostValidate event handler.Correct

OnPostValidate is raised immediately after an executable finishes its validation (verification) phase, before execution begins. Since the requirement specifically calls for an event raised when verification is completed, OnPostValidate directly maps to that lifecycle moment in the SSIS execution pipeline.

Concept tested: SSIS OnPostValidate event handler - post-validation lifecycle event

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

Topics

#OnPostValidate#event handlers#validation events#SSIS executables

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice