DRAG DROP
You plan to deploy a database to SQL Azure.
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.
• Allow USP_2 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.
Explanation:
Note:
* SP1: repeatable read
a repeatable read scan retains locks on every row it touches until the end of the transaction.
Even rows that do not qualify for the query result remain locked. These locks ensure that
the rows touched by the query cannot be updated or deleted by a concurrent session until
the current transaction completes (whether it is committed or rolled back).
* SP2: read uncommitted permits repeatable reads
this is from 70-464?
Repeated Read
Read Uncommited
Repeatable Read
Read Uncommitted
http://msdn.microsoft.com/en-us/library/ms173763.aspx
Pete, there is a similar questions in 70-464.