Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Google Exam Professional Cloud Database Engineer Topic 3 Question 49 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 49
Topic #: 3
[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?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

Ariel
20 days ago
Yeah, you know it's a tough one when the options include checking logs and manually performing failovers. Gotta love cloud administration.
upvoted 0 times
...
Vicente
23 days ago
Haha, imagine if the answer was just 'Do nothing and hope for the best'. That would be a classic IT exam question!
upvoted 0 times
Lorenza
4 days ago
Haha, that would definitely be a funny exam question! But in reality, it's important to follow the proper steps to minimize data loss and ensure availability.
upvoted 0 times
...
Coletta
7 days ago
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.
upvoted 0 times
...
Belen
12 days ago
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 the read replica instance.
upvoted 0 times
...
...
Lashaunda
1 months ago
I agree with Marva. Option C is the most robust solution that follows Google's recommended practices. The other options don't seem as reliable.
upvoted 0 times
...
Marva
1 months ago
Option C seems like the best choice here. Checking the replication status and then failing over to the read replica in region 2 is the recommended practice to minimize data loss.
upvoted 0 times
Rene
11 days ago
It's important to follow Google-recommended practices in situations like this.
upvoted 0 times
...
Arlean
17 days ago
Checking the replication status is crucial before failing over to the read replica.
upvoted 0 times
...
Leatha
18 days ago
I agree, option C is the best choice to minimize data loss.
upvoted 0 times
...
...
Elbert
1 months ago
I think checking the instance operational log for automatic failover status is also important before making a decision.
upvoted 0 times
...
Tamekia
1 months ago
I'm not sure, maybe we should just restore from automatic backups in another zone in region 1.
upvoted 0 times
...
Harrison
2 months ago
I agree with Glenn, that seems like the best option to minimize data loss.
upvoted 0 times
...
Glenn
2 months ago
I think we should check the replication status and fail over to region 2.
upvoted 0 times
...

Save Cancel