Google Exam Professional-Cloud-Database-Engineer Topic 4 Question 42 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 42
Topic #: 4

[All Professional Cloud Database Engineer Questions]

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?

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 instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

DCheck 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 .

Show Suggested Answer

Suggested Answer: C

https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery

by Coral at Sep 16, 2024, 01:39 PM

Limited Time Offer

25%

Off

Get Premium Professional-Cloud-Database-Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Eleni

4 days ago

I'd go with C. Promoting the read replica is the way to go, and checking the replication status is a smart move to ensure data integrity.

upvoted 0 times

...

Elli

5 days ago

Haha, I bet option D would be the one the IT guy who just woke up from a nap would recommend. 'Just check the logs, bro, it'll be fine!'

upvoted 0 times

...

Berry

7 days ago

I'm not sure about that. I think we should restore the Cloud SQL instance from the automatic backups in another zone in region 1.

upvoted 0 times

...

Lashawn

7 days ago

I'm not sure about option B. Restoring from a backup in the same region as the failed instance doesn't seem like it would minimize data loss.

upvoted 0 times

...

Nan

14 days ago

I agree with Laura. That seems like the best option to minimize data loss and follow Google-recommended practices.

upvoted 0 times

...

Laura

20 days ago

I think we should check the replication status using pg_catalog.pg_last_wal_receive_lsn and then fail over to region 2 by promoting the read replica instance.

upvoted 0 times

...

Florencia

21 days ago

C seems like the right choice here. The instructions mention following Google-recommended practices, and that's exactly what option C suggests - checking the replication status and failing over to the read replica.

upvoted 0 times

Golda

14 days ago

I think C is the best option here.

upvoted 0 times

...