The system requires an ACID-compliant database with minimal human intervention on failure. Which configuration meets this requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Configure a Cloud SQL for PostgreSQL instance with high availability enabled..
Why this is the answer
Cloud SQL for PostgreSQL with high availability (HA) enabled provides an ACID-compliant relational database with automatic failover to a standby instance in case of primary instance failure. This minimizes human intervention during outages, meeting the requirement. Point-in-time recovery for Cloud SQL (MySQL or PostgreSQL) is for data restoration, not automatic failover. Bigtable is a NoSQL wide-column store, not ACID-compliant, and while multi-cluster configurations offer high availability, they don't provide the transactional guarantees needed. BigQuery is a data warehouse designed for analytics, not an OLTP database requiring ACID compliance for transactional workloads, and its multi-region configuration is for data residency and availability, not real-time transactional failover.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed