Free 70-459 Real Exam Questions - Free 70-459 Dumps PDF

Question No 1

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?

A. Set the IMPLICIT_TRANSACTIONS option to off.
B. Set the XACT_ABORT option to off
C. Set the IMPLICIT_TRANSACTIONS option to on.
D. Set the XACT_ABORT option to on.

Answer: D

70-459 Practice Test