WHICH OF THE FOLLOWING DATABASE MIRRORING MODES REQUIRES THE USE OF...

4. Which of the following database mirroring modes requires the use of a witness

instance?

A. High Performance with automatic failover

B. High Performance

C. High Safety

D. High Safety with automatic failover

The correct answer is D. Automatic failover is available only with High Safety,

and only when a witness server is configured. High Safety can be used without

a witness server if automatic failover is not required but the loss of any transac-

tions is unacceptable.