ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam
Go to Exam

Exam 70-463 topic 2 question 52 discussion

Actual exam question from Microsoft's 70-463
Question #: 52
Topic #: 2
[All 70-463 Questions]

You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server Agent job is used to execute a package daily with the basic logging level.
Recently, the package execution failed because of a primary key violation when the package inserted data into the destination table.
You need to identify all previous times that the package execution failed because of a primary key violation.
What should you do?

  • A. Use an event handler for OnError for the package.
  • B. Use an event handler for OnError for each data flow task.
  • C. Use an event handler for OnTaskFailed for the package.
  • D. View the job history for the SQL Server Agent job.
  • E. View the All Messages subsection of the All Executions report for the package.
  • F. Store the System::SourceID variable in the custom log table.
  • G. Store the System::ServerExecutionID variable in the custom log table.
  • H. Store the System::ExecutionInstanceGUID variable in the custom log table.
  • I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.
  • J. Enable the SSIS log provider for SQL Server for OnTaskFailedin the package control flow. K. Deploy the project by using dtutil.exe with the /COPY DTS option. L. Deploy the project by using dtutil.exe with the /COPY SQL option. M. Deploy the .ispac file by using the Integration Services Deployment Wizard. N. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure. O. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure. P. Create a SQL Server Agent job to execute theSSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures. Q. Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table. R. Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by designsfactory at April 4, 2025, 11:55 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel