Microsoft
70-433 · Question #44
70-433 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
Question
You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 that hosts the Inventory database and transaction files. You notice that there are often blocking problems on the Inventory database. You discover that the blocking is caused by a SQL statement that operates in an isolation level set to repeatable read. How should you configure ABC-DB01 to reduce blocking whilst preventing dirty reads?
Options
- ABy making use of the WRITE UNCOMMITTED transaction isolation level.
- BBy making use of the WRITE COMMITTED transaction isolation level.
- CBy making use of the SNAPSHOT transaction isolation level.
- DBy making use of the NON SERIALIZABLE isolation level transaction.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 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.