Answer-first summary for fast verification
Answer: Configure a Cloud SQL for PostgreSQL instance with high availability enabled.
Choosing to configure a Cloud SQL for PostgreSQL instance with high availability ensures minimal human intervention during failures by automatically failing over to a standby replica in a different zone. This setup maintains ACID compliance. Other options either lack automatic failover capabilities (Options A, C, D) or are not ACID-compliant (Option A).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the best way to design an ACID-compliant database system that minimizes the need for human intervention during a failure?
A
Set up a BigQuery table with a multi-region configuration.
B
Configure a Cloud SQL for PostgreSQL instance with high availability enabled.
C
Set up a Bigtable instance with more than one cluster.
D
Configure a Cloud SQL for MySQL instance with point-in-time recovery enabled.