Microsoft
70-451 · Question #64
70-451 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a stored procedure that is created by using the following DDL code segment. You discover that the UPDATE statement occasionally throws an exception that causes the entire transaction to roll back. You need to ensure that when the UPDATE statement causes an exception, SP1 performs the following tasks: - The INSERT statement is committed, - All data is in a consistent state. - The Transaction count is equal to 0 after execution completes. What should you do?
Options
- A
- Add a TRY/CATCH block after the INSERT statement.
- B
- Add a TRY/CATCH block after the INSERT statement.
- C
- Add an XACT_ABORT ON statement to the first line of the procedure.
- D
- Add a SAVE TRANSACTION TR1 statement after the INSERT statement.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.