What is the purpose of a complete mirrored backup?

What is the purpose of a complete mirrored backup?

• A. Ensures against complete database destruction
• B. Improves query performance
• C. Logs daily user activity
• D. Tracks changes for auditing

Answer: (A)

Disaster recovery is the focus here. A complete mirrored backup is a full, exact copy of the entire database stored separately and kept in sync with the primary. Its purpose is to let you restore the database quickly and completely if the primary environment is lost, corrupted, or destroyed, protecting against total data loss. Because it captures all data in one go, you can bring the system back to the backup’s state without reconstructing anything from partial data. This is different from performance improvements, daily activity logging, or auditing—that data needs separate mechanisms, not a mirrored backup.

Disaster recovery is the focus here. A complete mirrored backup is a full, exact copy of the entire database stored separately and kept in sync with the primary. Its purpose is to let you restore the database quickly and completely if the primary environment is lost, corrupted, or destroyed, protecting against total data loss. Because it captures all data in one go, you can bring the system back to the backup’s state without reconstructing anything from partial data. This is different from performance improvements, daily activity logging, or auditing—that data needs separate mechanisms, not a mirrored backup.