Microsoft
70-459 · Question #41
You need to recommend a change to sp3 to ensure that the procedure completes only if all of the UPDATE statements complete. Which change should you recommend?
The correct answer is D. Set the XACT_ABORT option to on.. See the full explanation below for the reasoning.
Question
You need to recommend a change to sp3 to ensure that the procedure completes only if all of the UPDATE statements complete. Which change should you recommend?
Options
- ASet the IMPLICIT_TRANSACTIONS option to off.
- BSet the XACT_ABORT option to off
- CSet the IMPLICIT_TRANSACTIONS option to on.
- DSet the XACT_ABORT option to on.
How the community answered
(51 responses)- A14% (7)
- B6% (3)
- C4% (2)
- D76% (39)
Community Discussion
No community discussion yet for this question.