Hard1 markMultiple Choice
Subtask 2.2: Storage SystemsCloud SQLHigh AvailabilityDisaster RecoveryDatabase

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:

A.

Enable the Regional High Availability (HA) configuration on the primary Cloud SQL instance.

B.

Configure synchronous replication to the secondary region.

C.

Use Cloud Spanner instead, as Cloud SQL cannot support cross-region DR.

D.

Create a cross-region read replica in the secondary region.

E.

Export daily SQL dumps to a multi-region Cloud Storage bucket.

How to approach this question

Identify the Cloud SQL feature for zonal HA (Regional configuration) and the feature for regional DR (Cross-region replica).

Full Answer

To achieve High Availability (HA) in Cloud SQL, you enable the Regional HA configuration, which provisions a standby instance in a different zone and uses synchronous replication. To achieve Disaster Recovery (DR), you create a cross-region read replica. This replica receives data asynchronously. If the primary region goes down, you manually promote the cross-region replica to become the new primary.

Common mistakes

Assuming cross-region replication can be synchronous (Option B). The speed of light makes synchronous global replication impractical for standard relational databases.

Practice the full GCP Professional Cloud Architect Practice Exam 7

50 questions · hints · full answers · grading

More questions from this exam