nerdexam
Microsoft

70-458 · Question #27

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…

The correct answer is C. OnPostExecute. See the full explanation below for the reasoning.

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

(26 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    81% (21)
  • D
    12% (3)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice