MENU
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?
Suggested Answer: C
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
32 comments · newest first
GL
Glory
11 months ago
I disagree with D, manual failover adds unnecessary steps.
HE
Heike
11 months ago
D could work too, but it might take longer to check logs.
ST
Stephaine
11 months ago
Surprised that people are considering B. C seems way more efficient!
BR
Brittney
11 months ago
I think B is better. Why restore from another zone when you have a replica?
CH
Chauncey
12 months ago
Option C is the way to go! Promoting the read replica is key.
QU
Quiana
12 months ago
I’m a bit confused about the best approach. Should we rely on the read replica or go for backups? I guess it depends on how much data we can afford to lose.
TU
Tu
1 year ago
I practiced a similar question, and I feel like option D could be useful too, especially if the failover happens automatically. But what if it doesn't?
IL
Iluminada
1 year ago
I'm not entirely sure, but I remember something about automatic backups being crucial. Maybe option A could be a fallback if the read replica isn't up to date?
JO
Joanna
1 year ago
I think option C makes sense because it involves checking the replication status before promoting the read replica. That seems like a good way to minimize data loss.
ST
Stephane
1 year ago
Hmm, I'm not sure about this. There are a lot of details to consider, like the automatic failover status and the location of the backups. I think I'll need to carefully read through each option and the question again to make sure I understand everything before answering.
HA
Hassie
1 year ago
I'm a bit confused by all the options. I'm not sure if I should be restoring from backups or trying to fail over to the read replica. Maybe I should review the Google documentation on Cloud SQL failover procedures again.
YE
Yen
1 year ago
This seems like a tricky question, but I think the key is to follow Google's recommended practices. Option C looks promising since it involves checking the replication status and then failing over to the read replica.
HE
Hector
1 year ago
Okay, I think I've got this. Option C is definitely the way to go. Checking the replication status and then failing over to the read replica is the best way to minimize data loss and follow Google's recommendations. I feel pretty confident about this one.
TA
Tamie
1 year ago
Developing an open-source package or SDK seems like a lot of work for an exam question. I think I'd focus on the more practical options like using the API Inspector and NETCONF.
EL
Eleni
2 years 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.
GE
Georgene
2 years ago
I agree, promoting the read replica after checking the replication status is the recommended practice. C it is.
RO
Rozella
2 years ago
Agreed, checking the replication status is crucial to avoid data loss. Let's go with C.
NO
Novella
2 years ago
I think C is the best option. Promoting the read replica seems like the safest choice.
EL
Elli
2 years 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!'
BE
Berry
2 years 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.
LA
Lashawn
2 years 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.
BE
Beckie
2 years ago
Exactly, it's important to prioritize data consistency and minimizing data loss in scenarios like this.
GL
Gladys
2 years 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.
IL
Ilene
2 years ago
I agree, option C seems to follow Google-recommended practices for minimizing data loss in this situation.
CA
Carissa
2 years 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.
NA
Nan
2 years ago
I agree with Laura. That seems like the best option to minimize data loss and follow Google-recommended practices.
LA
Laura
2 years 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.
FL
Florencia
2 years 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.
BA
Barrie
2 years ago
Let's go with option C then.
PO
Pok
2 years ago
That sounds like the most reliable choice.
HO
Holley
2 years ago
I agree, C involves checking replication status and failing over to the read replica.
GO
Golda
2 years ago
I think C is the best option here.