You administer two SQL Server 2008 instances on separate servers named Server1 and
Server2.
The AdventureWorks database is set up for synchronous mirroring between the two
instances.
You need to configure the database to support automatic failover.
What should you do?
A.
Configure the mirroring session by using the FAILOVER option.
B.
Configure the mirroring session with the SAFETY option set to OFF.
C.
Configure the mirroring session with the SAFETY option set to FULL.
D.
Configure the mirroring session by adding a witness server to it.