You plan to deploy a database to SQL Azure. You are designing two stored procedures named SP1 and SP2
that have the following requirements:
Prevent data read by SP1 from being modified by other active processes.
Allow SP2 to perform dirty reads.
You need to recommend the isolation level for the stored procedures. The solution must maximize concurrency.
Which isolation levels should you recommend? To answer, drag the appropriate isolation level to the correct
stored procedure in the answer area.
Select and Place:
Answer: 