QuestionQ26

Maintaining and automating data workloads

You are designing a system that needs an ACID-compliant database. You must ensure the system needs minimal human intervention if a failure occurs.

What should you do?

Explanation

A highly available Cloud SQL for PostgreSQL instance is a relational, ACID-compliant database configuration with a standby instance in a secondary zone. If the primary instance or zone fails, Cloud SQL automatically fails over to the standby, minimizing required human intervention. Point-in-time recovery restores data to a chosen time but does not provide automatic failover.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!