Exam 70-464 topic 1 question 83 discussion

Actual exam question from Microsoft's 70-464

Question #: 83
Topic #: 1

You use SQL Server to maintain the data used by applications at your company.
You need to run two separate SQL statements.
You must guarantee that the following three things happen:
Either BOTH statements succeed or BOTH statements fail as a batch.

✑ If an error occurs on the first statement, SQL should not attempt to run the second statement.
✑ Error information should be returned to the client.
What should you do?

A. Option A
B. Option B
C. Option C
D. Option D

Show Suggested Answer

Suggested Answer: A 🗳️
* SET XACT_ABORT
When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.
When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing.

by Williamzhou at Nov. 25, 2020, 5:59 p.m.

Comments

Submit Cancel

LiamLin

3 years, 9 months ago

Should be answer D. Answer C doesn't have commit transaction

upvoted 1 times

...

Williamzhou

4 years, 6 months ago

I think correct answer is C. Answer A doesn't have error returned to client.

upvoted 1 times

...