You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity including retrieving identical sets across reads in all situations that use
transactions.
Which isolation level should you use?
A.
Repeatable
B.
Serializable
C.
ReadUncommitted
D.
ReadCommitted
Explanation:
REPEATABLE READ
Specifies that statements cannot read data that has been modified but not yet committed by other transactions
and that no other transactions can modify data that has been read by the current transaction until the current
transaction completes.
Shouldn’t use serializable to maintain data integrity??
I think REPEATABLE READ is the correct choice, ’cause it maintain the integrity of the existing data.
https://stackoverflow.com/questions/4034976/difference-between-read-commit-and-repeatable-read
I think the answer is serialize
http://www.aiotestking.com/microsoft/you-need-to-maintain-data-integrity-in-all-situations-that-use-transactions-5/
or
https://borntolearn.mslearn.net/certification/developer/f/532/t/325643