Microsoft
70-433 · Question #105
You have a transaction that uses the repeatable read isolation level. This transaction causes frequent blocking problems. You need to reduce blocking. You also need to avoid dirty reads and…
The correct answer is A. SNAPSHOT. See the full explanation below for the reasoning.
Question
You have a transaction that uses the repeatable read isolation level. This transaction causes frequent blocking problems. You need to reduce blocking. You also need to avoid dirty reads and non-repeatable reads. Which transaction isolation level should you use?
Options
- ASNAPSHOT
- BSERIALIZABLE
- CREAD COMMITTED
- DREAD UNCOMMITTED
How the community answered
(46 responses)- A78% (36)
- B13% (6)
- C2% (1)
- D7% (3)
Community Discussion
No community discussion yet for this question.