ExpertMedium1 markMultiple Choice
Domain 2: Managing and Provisioning a Solution InfrastructureDomain 2Cloud SQLHigh AvailabilityDatabase
GCP PCA · Question 32 · Domain 2: Managing and Provisioning a Solution Infrastructure
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?
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?
Answer options:
A.
Create a Read Replica in a different zone.
B.
Enable High Availability (HA) on the Cloud SQL instance.
C.
Configure automated daily backups and store them in a multi-region bucket.
D.
Use Cloud Spanner instead.
How to approach this question
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.
Full Answer
B.Enable High Availability (HA) on the Cloud SQL instance.✓ Correct
Enable High Availability (HA) on the Cloud SQL instance.
Cloud SQL High Availability (HA) provides redundancy within a single region. It uses a Regional Persistent Disk to synchronously replicate data between a primary zone and a standby zone. If an outage occurs, the IP address automatically swings to the standby instance, ensuring continuous availability without manual intervention.
Common mistakes
Choosing Read Replicas (A). Read replicas are asynchronous, meaning data loss is possible during a sudden failure, and they do not failover automatically.
Practice the full GCP Professional Cloud Architect Practice Exam 3
50 questions · hints · full answers · grading
More questions from this exam
Q01**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...MediumQ02**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...HardQ03**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...MediumQ04**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...EasyQ05**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...Medium