Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - 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 Exam Professional Cloud Database Engineer 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:

Submit Cancel
Olene
30 days 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
6 days 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
17 days 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
18 days ago
A) Create one regional Cloud SQL instance with a read replica in another region.
upvoted 0 times
...
...
Annice
1 months 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 months 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
Marya
16 days ago
I agree, option D seems like overkill.
upvoted 0 times
...
Shannan
19 days ago
I think option B is the most efficient solution.
upvoted 0 times
...
...
Lawana
1 months 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
Felton
9 days ago
A) Create one regional Cloud SQL instance with a read replica in another region.
upvoted 0 times
...
...
Celia
2 months 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
2 months ago
Agreed, having a regional instance with a standby in another zone is a solid setup.
upvoted 0 times
...
Ashlee
2 months ago
I think option B is the best choice for high availability.
upvoted 0 times
...
...
Tuyet
2 months 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
2 months 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
3 months ago
I think option B is the best choice because it provides high availability within the same region.
upvoted 0 times
...

Save Cancel