You have a mission critical database named MCDB1 that you want to configure for automatic failover. You have decided to utilize database mirroring. Which database mirroring operating mode should you use?
-
High safety mode
-
Asynchronously
-
High performance mode
-
Synchronously
A
Correct answer
Explanation
High safety mode (also called high safety with automatic failover) is the correct database mirroring operating mode for mission critical databases requiring automatic failover. In this mode, transactions are committed synchronously to both principal and mirror servers before acknowledging success, ensuring zero data loss. High performance mode is asynchronous and doesn't support automatic failover.