You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You have a database named CorpDB. You plan to create a stored procedure
to access data in CorpDB. You need to ensure that the stored procedure supports dirty reads. What should you
do?
A.
You should configure the stored procedure to use the READ UNCOMMITTED isolation level.
B.
You should configure the stored procedure to use the READ COMMITTED isolation level.
C.
You should configure the stored procedure to use the READ SERIALIZABLE isolation level.
D.
You should configure the stored procedure to use the REPEATABLE READ isolation level.
E.
You should configure the stored procedure to use the SNAPSHOT isolation level.
A. is the correct answer.
Read uncommitted modifications, are also called dirty reads.
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql