Hard1 markMultiple Choice
Subtask 4.1: Analyze and define technical processesDisaster RecoveryCloud SQLRead Replicas

GCP PCA · Question 49 · Analyze and define technical processes

Your organization wants to implement a robust disaster recovery strategy for a critical Cloud SQL database. The database is currently in us-central1. The RPO is 10 minutes, and the RTO is 1 hour. Which THREE configurations are required to achieve this? (Select THREE)

Answer options:

A.

Enable automated backups on the primary instance.

B.

Create a Cross-Region Read Replica in us-east1.

C.

In a disaster, promote the Cross-Region Read Replica to a standalone primary instance.

D.

Enable High Availability (HA) on the primary instance.

E.

Configure synchronous replication to the cross-region replica.

F.

Export the database to Cloud Storage every 10 minutes.

How to approach this question

Identify the steps to set up and execute a cross-region failover in Cloud SQL.

Full Answer

Enable automated backups on the primary instance., Create a Cross-Region Read Replica in `us-east1`., In a disaster, promote the Cross-Region Read Replica to a standalone primary instance.
For cross-region disaster recovery in Cloud SQL: 1) Automated backups must be enabled on the primary. 2) You create a Cross-Region Read Replica (e.g., in us-east1). Data replicates asynchronously, keeping the RPO very low. 3) If us-central1 goes down, you manually 'promote' the replica. Promotion stops replication and turns the replica into a standalone, writable primary instance, satisfying the RTO.

Common mistakes

Assuming High Availability (HA) provides cross-region DR. HA is only cross-zone within the same region.

Practice the full GCP Professional Cloud Architect Practice Exam 1

50 questions · hints · full answers · grading

More questions from this exam