Answers A and D are correct. To achieve automatic failover of a mirrored database set, you must have the mirror configured for synchronous delivery, and you also need to have a witness configured. The witness actually identifies the state in which the failover is triggered. For more information, see the following sources:
|