Answer-first summary for fast verification
Answer: Implement routinely scheduled failovers of your databases
The correct answer is D: Implement routinely scheduled failovers of your databases. Regularly scheduled failovers help ensure that the failover mechanism is tested and functional, making sure that the replica can automatically be promoted to primary when needed. This is essential for minimizing downtime and ensuring the system's reliability during unexpected primary database failures. Options A, B, and C do not directly address the issue of ensuring the replica is promoted to primary during a crash.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a relational database system that experiences high traffic at certain times of the day. During one such peak traffic period, the primary database instance crashes, and the standby replica fails to be promoted to the primary role, leading to service disruption. What should you do to prevent this issue from occurring in the future?
A
Use a different database
B
Choose larger instances for your database
C
Create snapshots of your database more regularly
D
Implement routinely scheduled failovers of your databases
No comments yet.