Answer-first summary for fast verification
Answer: Configure high availability.
A. Incorrect. Replication on Cloud SQL is effective to offload reads. However, it does not support a full read-write database. B. Correct. Configuring high availability on Cloud SQL will automatically switch to the secondary instance when the primary instance goes down, thus reducing downtime for the database's users. C. Incorrect. Backups are useful to retrieve older data in case of catastrophic failures such as accidental data deletion. However, they don’t provide continuous availability of the database, because restoring the database takes time. D. Incorrect. Increasing the number of backups does not impact or improve availability. Although there are more backups, restoring the database in case of failure incurs downtime.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You run a Cloud SQL instance for a business that requires that the database is accessible for transactions. You need to ensure minimal downtime for database transactions.
A
Configure replication.
B
Configure high availability.
C
Configure backups.
D
Configure backups and increase the number of backups.