Developing Microsoft Azure and Web Services — Question 102

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity in all situations that use transactions.

Answer options

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

Correct answer: C

Explanation

The correct answer is Serializable because it provides the strictest isolation level, ensuring that transactions are completely isolated from one another, thus maintaining data integrity. The other options, such as ReadUncommitted and ReadCommitted, allow for varying degrees of reading uncommitted changes, which can compromise integrity, while Repeatable allows for some concurrency but does not provide the same level of isolation as Serializable.