Microsoft
70-465 · Question #94
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 proce
Sign in or unlock 70-465 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
Submitted by lucia.co· Mar 5, 2026Design and implement database solutions for SQL Server
Question
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?
Options
- AYou should configure the stored procedure to use the READ UNCOMMITTED isolation level.
- BYou should configure the stored procedure to use the READ COMMITTED isolation level.
- CYou should configure the stored procedure to use the READ SERIALIZABLE isolation level.
- DYou should configure the stored procedure to use the REPEATABLE READ isolation level.
- EYou should configure the stored procedure to use the SNAPSHOT isolation level.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Transaction isolation levels#Dirty reads#READ UNCOMMITTED#Stored procedure design