Hard1 markMultiple Choice
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)
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
Q01**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...HardQ02**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...MediumQ03**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...HardQ04**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...MediumQ05**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...Medium
Expert