Microsoft
70-433 · Question #44
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…
The correct answer is C. By making use of the SNAPSHOT transaction isolation level. See the full explanation below for the reasoning.
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.
How the community answered
(54 responses)- A7% (4)
- B13% (7)
- C78% (42)
- D2% (1)
Community Discussion
No community discussion yet for this question.