Google Cloud Professional Data Engineer — Question 313

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because configuring a Cloud SQL for PostgreSQL instance with high availability provides automatic failover and redundancy, ensuring minimal downtime. Option A, while useful, does not guarantee high availability. Options C and D do not offer ACID compliance, making them unsuitable for this requirement.