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?
A.
Configure manual failover role switching.
B.
Configure forced service role switching.
C.
Pause database mirroring.
D.
Configure automatic failover role switching.