Developing Microsoft Azure and Web Services — Question 2

You are developing an application that reads and writes data from a SQL Server database.
You need to ensure transactional data integrity.
Which isolation level should you use?

Answer options

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

Correct answer: C

Explanation

The correct answer is C, ReadUncommitted, which allows reading data that has not yet been committed, thus ensuring the application can continue to function without being blocked by uncommitted transactions. Options A and B, Serializable and ReadCommitted respectively, provide stricter isolation levels that can lead to higher contention and reduced performance for certain applications. Option D, Normal, is not a recognized isolation level in SQL Server.