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?
Setting up database mirroring across multiple servers
Implementing RAID on the database server's storage system
Creating a regular backup schedule for the database
Transitioning the database to a more robust mainframe
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 and how does it work?
Open an interactive chat with Bash
What is RAID and how does it provide fault tolerance?
Open an interactive chat with Bash
What are the advantages and limitations of using a regular backup schedule?