DRAG DROP
You plan to deploy SQL Server 2012.
You are designing two stored procedures named USP_1 and USP_2 that have the following
requirements:
• Prevent data read by USP_1 from being modified by other active processes.
• Prevent USP_2 from performing dirty reads.
You need to recommend the isolation level for each stored procedure. 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.

Answer:

Explanation:

Note:
* REPEATABLE READ

This isolation level includes the guarantees given by SNAPSHOT isolation level. In addition,
REPEATABLE READ guarantees that for any row that is read by the transaction, at the time
the transaction commits the row has not been changed by any other transaction. Every read
operation in the transaction is repeatable up to the end of the transaction.
* Committed Read is SQL Server’s default isolation level. It ensures that an operation will
never read data another application has changed but not yet committed.