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
Correct
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/use-marked-transactions-to-recover-related-databases-consistently?view=sql-server-2017
1
0