GCP PCA · Question 38 · Storage Systems
You are designing the database architecture for a mission-critical application using Cloud SQL for PostgreSQL. The application requires High Availability (HA) within the primary region to survive zone failures, and Disaster Recovery (DR) in a secondary region to survive a full region outage. Which TWO configurations must you implement? (Select TWO)
Answer options:
Enable the Regional High Availability (HA) configuration on the primary Cloud SQL instance.
Configure synchronous replication to the secondary region.
Use Cloud Spanner instead, as Cloud SQL cannot support cross-region DR.
Create a cross-region read replica in the secondary region.
Export daily SQL dumps to a multi-region Cloud Storage bucket.
50 questions · hints · full answers · grading