Microsoft
70-450 · Question #28
You administer a SQL Server 2008 instance. You plan to design a high-availability solution by using database mirroring. The current application includes programming logic that will retry…
The correct answer is C. Configure forced service role switching. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance. You plan to design a high-availability solution by using database mirroring. The current application includes programming logic that will retry transactions if a failover occurs. You need to configure a strategy that will provide the minimum amount of latency for committed transactions. What should you do?
Options
- APause database mirroring.
- BConfigure manual failover role switching.
- CConfigure forced service role switching.
- DConfigure automatic failover role switching.
How the community answered
(27 responses)- A11% (3)
- B4% (1)
- C78% (21)
- D7% (2)
Community Discussion
No community discussion yet for this question.