Developing Microsoft Azure and Web Services — Question 55

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to prevent the application from reading data that is locked by other transactions. You also need to prevent exclusive range locks.
Which isolation level should you use?

Answer options

• A. ReadCommitted
• B. Serializable
• C. Repeatable
• D. ReadUncommitted

Correct answer: A

Explanation

The ReadCommitted isolation level allows transactions to read only committed data, thus preventing reading from locked resources. Serializable would be too strict and could lead to exclusive locks, while Repeatable and ReadUncommitted do not meet the requirements to prevent reading locked data effectively.