Multiple choice technology databases

What is one of the disadvantages of database mirroring?

  1. You need to have the same hardware.

  2. The database you mirror to will be in an unused standby state.

  3. You cannot have automatic failover.

  4. You need to have at minimum three servers.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In database mirroring, the mirror database remains in a restoring/standby state and cannot be directly read or written to by users, representing idle capacity. Identical hardware is not strictly mandatory, automatic failover is supported, and a witness server is optional.

Keep practicing — related questions