Answer-first summary for fast verification
Answer: Configure a Cloud SQL for PostgreSQL instance with high availability enabled.
**Explanation:** The best option to meet the ACID compliance and minimal human intervention requirements is to configure a Cloud SQL for PostgreSQL instance with high availability enabled. Key reasons: - **Cloud SQL for PostgreSQL** provides full ACID compliance, unlike Bigtable which provides only atomicity and consistency guarantees - **High availability enabled** removes the need for manual failover as Cloud SQL will automatically failover to a standby replica if the leader instance goes down - **Automatic failover** ensures availability and uptime without administrative effort Other options have limitations: - Option A: Point-in-time recovery in MySQL requires manual intervention to restore data if needed - Option C: Bigtable does not provide full ACID compliance required for transactional systems - Option D: BigQuery does not provide transactional guarantees required for an ACID database
Author: LeetQuiz .
Ultimate access to all questions.
NO.7 You are designing a system that requires an ACID-compliant database. You must ensure that the system requires minimal human intervention in case of a failure. What should you do?
A
Configure a Cloud SQL for MySQL instance with point-in-time recovery enabled.
B
Configure a Cloud SQL for PostgreSQL instance with high availability enabled.
C
Configure a Bigtable instance with more than one cluster.
D
Configure a BigQuery table with a multi-region configuration.
No comments yet.