A database administrator is tasked with ensuring high availability and fault tolerance for a critical database that must operate 24/7. Which of the following solutions should be implemented to meet these requirements?
Transitioning the database to a more robust mainframe
Creating a regular backup schedule for the database
Setting up database mirroring across multiple servers
Implementing RAID on the database server's storage system
Configuring database mirroring involves having multiple database instances that are exact copies of each other. In case the primary database fails, one of the mirrored databases can take over, ensuring that the database service remains available. While RAID can protect against disk failures, it does not cover the entire database system failure. A single mainframe, regardless of its robustness, represents a single point of failure. A regular backup schedule provides a way to restore data but does not guarantee high availability in real-time.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is database mirroring?
Open an interactive chat with Bash
How does RAID contribute to fault tolerance?
Open an interactive chat with Bash
Why is a backup schedule not enough for high availability?