Question 1

You are designing a highly available architecture for a critical web application. The database tier uses Cloud SQL for PostgreSQL. You need to ensure that if the primary zone goes down, the database automatically fails over to another zone with zero data loss. How should you configure Cloud SQL?

Accepted Answer

Understand the difference between HA and Read Replicas in Cloud SQL. HA provides synchronous replication and automatic failover. Read Replicas provide asynchronous replication and require manual promotion.

Question 2

What mistakes do candidates make on this GCP PCA question?

Accepted Answer

Choosing Read Replicas (A). Read replicas are asynchronous, meaning data loss is possible during a sudden failure, and they do not failover automatically.

You are designing a highly available architecture for a critical web application. The database tier uses Cloud SQL for PostgreSQL. You need to ensure that if the primary zone goes down, the database automatically fails over to another zone with zero data loss. How should you configure Cloud SQL?

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Professional Cloud Architect Practice Exam 3

More questions from this exam