Exam 70-461 topic 1 question 87 discussion

Actual exam question from Microsoft's 70-461

Question #: 87
Topic #: 1

You use Microsoft SQL Server to develop a database application.
You create a stored procedure named dbo.ModifyData that can modify rows.
You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
✑ Does not return an error
✑ Closes all opened transactions
Which Transact-SQL statement should you use?

A. BEGIN TRANSACTION BEGIN TRY EXEC dbo.ModifyData COMMIT TRANSACTION END TRY BEGIN CATCH IF @@ TRANCOUNT = 0 ROLLBACK TRANSACTION; END CATCH
B. BEGIN TRANSACTION BEGIN TRY EXEC dbo.ModifyData COMMIT TRANSACTION END TRY BEGIN CATCH IF @@ERROR != 0 ROLLBACK TRANSACTION; THROW; END CATCH
C. BEGIN TRANSACTION BEGIN TRY EXEC dbo.ModifyData COMMIT TRANSACTION END TRY BEGIN CATCH IF @@TRANCOUNT = 0 ROLLBACK TRANSACTION; THROW; END CATCH
D. BEGIN TRANSACTION BEGIN TRY EXEC dbo.ModifyData COMMIT TRANSACTION END TRY BEGIN CATCH IF @@ERROR != 0 ROLLBACK TRANSACTION; END CATCH

Show Suggested Answer

Suggested Answer: D 🗳️

by lilupv at Aug. 3, 2020, 10:54 a.m.

Comments

Submit Cancel

lilupv

4 years, 10 months ago

Probably, D has to be finished with END CATCH

upvoted 1 times

...