Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 121

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?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting th...

Google Cloud Professional Cloud Database Engineer PCDBE — Question 121