You have a Microsoft SQL Azure database.
You have the following stored procedure:
You discover that the stored procedure periodically fails to update HR.Employees.
You need to ensure that HR.Employees is always updated when up_employees executes.
The solution must minimize the amount of time required for the stored procedure to execute and the number of
locks held.
What should you do?
A.
Add the following line of code to line 05:
SET TRANSACTION ISOLATION LEVEL SNAPSHOT
B.
Add the following line of code to line 13:
WITH (UPDLOCK)
C.
Add the following line of code to line 05:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
D.
Add the following line of code to line 08:
WITH (UPDLOCK)