PrepAway - Latest Free Exam Questions & Answers

What should you add next to the beginning of each store…

You need to implement a solution that meets the data recovery requirements.
You update each stored procedure to accept a parameter named @transactionID.
What should you add next to the beginning of each stored procedure?A. SAVE TRANSACTION WITH MARK @transactionID

B.
ROLLBACK DISTRIBUTED TRANSACTION @transactionID

C.
BEGIN TRANSACTION WITH MARK @transactionID

D.
COMMIT TRANSACTION @transactionID

Leave a Reply