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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Cloud Database Engineer Exam - Topic 1 Question 44 Discussion

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
D) Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
A) Create one regional Cloud SQL instance with a read replica in another region.
B) Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
C) Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

Google Professional Cloud Database Engineer Exam - Topic 1 Question 44 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 44
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: D

Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria


by Rosalyn at Sep 16, 2024, 01:16 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Laquanda
9 months ago
I didn’t know standby instances could be in different zones!
upvoted 0 times
...
Francisca
9 months ago
Definitely going with B, it’s the standard setup for failover.
upvoted 0 times
...
Desirae
10 months ago
Wait, why would you need two read-write instances? Seems overkill.
upvoted 0 times
...
Delbert
10 months ago
I think A could work too, but not as reliable.
upvoted 0 times
...
Gertude
10 months ago
Option B is the best choice for high availability.
upvoted 0 times
...
Nakisha
10 months ago
Option D seems excessive with two read-write instances in different regions; I think we only need one standby for failover, right?
upvoted 0 times
...
Tien
11 months ago
I practiced a similar question where the focus was on regional setups, and I feel like option B aligns with that, but I’m still a bit confused about the zones.
upvoted 0 times
...
Alberta
11 months ago
I'm not entirely sure, but I remember something about read replicas not providing automatic failover, so maybe options A and C aren't the best choices.
upvoted 0 times
...
Emerson
11 months ago
I think option B sounds familiar because it mentions a standby instance in another zone, which is important for high availability.
upvoted 0 times
...
Florinda
11 months ago
Creating two read-write instances in different regions sounds like the most robust solution to me. I'll select option D.
upvoted 0 times
...
Vincenza
11 months ago
Hmm, I'm a bit unsure about the difference between a read replica and a standby instance. I'll need to review those concepts before deciding.
upvoted 0 times
...
Omega
11 months ago
This seems like a straightforward high availability question. I'll carefully read through the options and think about the key requirements.
upvoted 0 times
...
Janessa
11 months ago
Okay, I think I've got this. The key is to have redundancy across zones and regions to ensure high availability. I'll go with option B.
upvoted 0 times
...
Halina
11 months ago
The tricky part is identifying what's genuinely unique, not just a general problem. Option D sounds most cloud-specific to me.
upvoted 0 times
...
Olene
1 year ago
Hmm, I wonder if the app team has considered the potential latency issues with a multi-region setup. A regional instance with a local standby seems like the way to go.
upvoted 0 times
Miesha
1 year ago
Hmm, I wonder if the app team has considered the potential latency issues with a multi-region setup. A regional instance with a local standby seems like the way to go.
upvoted 0 times
...
Hortencia
1 year ago
B) Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
upvoted 0 times
...
Glendora
1 year ago
A) Create one regional Cloud SQL instance with a read replica in another region.
upvoted 0 times
...
...
Annice
1 year ago
Haha, I bet the application team is hoping for zero downtime. Good thing they're not asking for 99.999% uptime, or they'd have to build a whole data center underground!
upvoted 0 times
...
Vanna
1 year ago
Option D is overkill. Creating two read-write instances in different regions is unnecessary for this use case. B is the most efficient solution.
upvoted 0 times
Bronwyn
1 year ago
Let's go with creating one regional Cloud SQL instance in one zone with a standby instance in another zone.
upvoted 0 times
...
Josefa
1 year ago
Having a standby instance in another zone in the same region is a good idea.
upvoted 0 times
...
Marya
1 year ago
I agree, option D seems like overkill.
upvoted 0 times
...
Shannan
1 year ago
I think option B is the most efficient solution.
upvoted 0 times
...
...
Lawana
1 year ago
I agree with Celia. Having a standby instance in a different zone provides the redundancy and automatic failover that the application team needs.
upvoted 0 times
Portia
1 year ago
C) Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
upvoted 0 times
...
Avery
1 year ago
B) Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
upvoted 0 times
...
Felton
1 year ago
A) Create one regional Cloud SQL instance with a read replica in another region.
upvoted 0 times
...
...
Celia
1 year ago
Option B is the way to go! A regional instance with a standby in another zone is the perfect setup for high availability.
upvoted 0 times
Lorrine
1 year ago
Agreed, having a regional instance with a standby in another zone is a solid setup.
upvoted 0 times
...
Ashlee
1 year ago
I think option B is the best choice for high availability.
upvoted 0 times
...
...
Tuyet
1 year ago
That's a valid point, but having a standby instance in the same region like in option B can also provide quick failover.
upvoted 0 times
...
Mariann
1 year ago
I disagree, I believe option A is better as it offers a read replica in another region for better fault tolerance.
upvoted 0 times
...
Tuyet
1 year ago
I think option B is the best choice because it provides high availability within the same region.
upvoted 0 times
...

Save Cancel