PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #93
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQ
The correct answer is C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica. No need for restores if you have a read replica which you can promote to be the new primary. Eliminate A and B. Failovers do not happen automatically to read replicas. You have to promote them. Eliminate D. That leaves C which is supported by Google's documentation. https://cloud
Question
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google- recommended practices. What should you do?
Options
- ARestore the Cloud SQL instance from the automatic backups in region 3.
- BRestore the Cloud SQL instance from the automatic backups in another zone in region 1.
- CCheck "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica
- DCheck your instance operational log for the automatic failover status. Look for time, type, and
How the community answered
(38 responses)- A11% (4)
- B8% (3)
- C79% (30)
- D3% (1)
Explanation
No need for restores if you have a read replica which you can promote to be the new primary. Eliminate A and B. Failovers do not happen automatically to read replicas. You have to promote them. Eliminate D. That leaves C which is supported by Google's documentation. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
Topics
Community Discussion
No community discussion yet for this question.