You are managing a Cloud SQL for PostgreSQL instance in Google 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?

Accepted Answer

C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status usingpg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

Answer

A. Restore the Cloud SQL instance from the automatic backups in region 3.

Answer

B. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

Answer

D. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Exam Professional-Cloud-Database-Engineer All Questions

Google Cloud Database Engineer Professional-Cloud-Database-Engineer Question # 25 Topic 3 Discussion

Correct Answer:

Options Selected by Other Users:

Contribute your Thoughts: