Skip to main content

Question 197

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.

https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform-pitr

https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview