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

5 months 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

Georgene

4 months ago

I agree, promoting the read replica after checking the replication status is the recommended practice. C it is.

upvoted 0 times

...

Rozella

4 months ago

Agreed, checking the replication status is crucial to avoid data loss. Let's go with C.

upvoted 0 times

...

Novella

4 months ago

I think C is the best option. Promoting the read replica seems like the safest choice.

upvoted 0 times

...

Elli

5 months 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

5 months 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

5 months 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

Beckie

4 months ago

Exactly, it's important to prioritize data consistency and minimizing data loss in scenarios like this.

upvoted 0 times

...

Gladys

4 months ago

Restoring from a backup in a different region might not have the most up-to-date data compared to the read replica in region 2.

upvoted 0 times

...

Ilene

5 months ago

I agree, option C seems to follow Google-recommended practices for minimizing data loss in this situation.

upvoted 0 times

...

Carissa

5 months ago

Option C sounds like the best choice. Checking the replication status and failing over to the read replica in region 2 seems like the safest bet.

upvoted 0 times

...

Nan

5 months ago

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

upvoted 0 times

...

Laura

5 months 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

5 months 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