PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the stored procedure supports dirty reads

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?

PrepAway - Latest Free Exam Questions & Answers

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 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.

Explanation:


Leave a Reply