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