070-465 Free Dumps Study Materials
Question 7: You are building a stored procedure for a Windows Azure SQL Database. The procedure will add
multiple rows to a table.
You need to design the stored procedure to meet the following requirements:
If any of the new rows violates a table constraint, then no further additions must be attempted and
all changes made by the stored procedure must be discarded.
If any errors occur, a row must be added to an audit table, and the original error must be returned to
the caller of the stored procedure.
What should you include in the design?
A. An explicit transaction that has XACT_ABORT disabled
B. An implicit transaction that has error handling enabled
C. An explicit transaction that has error handling enabled
D. An implicit transaction that has XACT.ABORT enabled
Correct Answer: C
Reference:
http://technet.microsoft.com/en-us/library/ms175127(v=SQL.105).aspx