MENU
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
Suggested Answer: A
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
39 comments · newest first
BR
Brandee
10 months ago
A sounds solid, but I’m not sure about the zone distribution.
WI
Willie
10 months ago
I think C might be better for disaster recovery.
EL
Elroy
11 months ago
Wait, can you really have instances in different regions?
LO
Louvenia
11 months ago
Definitely not D, that’s just asking for trouble.
GL
Gladys
11 months ago
Option A is the way to go for high availability!
WH
Whitney
11 months ago
I recall a similar question where we had to choose zones for redundancy. I think option B might not be ideal since it puts both primary and standby in the same zone.
EL
Eleonora
11 months ago
I’m a bit confused about the regions. I thought having the standby in a different region could be beneficial, but I’m not sure if that’s the best practice here.
AN
Antonio
12 months ago
I think option A sounds right because it spreads the instances across different zones, which is what we practiced in class.
RI
Rikki
12 months ago
I remember that high availability setups usually require instances in different zones, but I'm not sure if they should all be in the same region.
HO
Hobert
1 year ago
I'm feeling pretty confident about this one. The answer is B - configure the primary and standby instances in zone A and the read replica in zone B, all in the same region. That way, we get high availability and can still maintain low latency for the read replica.
AR
Arlene
1 year ago
Okay, I've got this. Based on the question, the best approach is to configure the primary and standby instances in different zones within the same region, and then add a read replica in a separate zone. That way, we have redundancy and can handle zone-level failures.
PA
Paola
1 year ago
Hmm, I'm a bit confused. I know we need to ensure high availability, but I'm not sure if we should put the instances in different regions or just different zones within the same region. I'll need to review the Google documentation again.
EL
Elinore
1 year ago
This seems pretty straightforward. I think the key is to follow Google's recommended practices for high availability, which means spreading the instances across different zones and regions.
LO
Lonna
1 year ago
Option A sounds like a good compromise, but I think B is the clear winner here. Separating the read replica from the primary and standby is a smart move.
CA
Cary
1 year ago
Haha, option D is like putting all your eggs in one basket! I'll have to go with B, it's the Google-recommended practice and makes the most sense.
IR
Ira
1 year ago
Let's go with B then, better safe than sorry.
SO
Socorro
1 year ago
I agree, Google probably knows best when it comes to high availability.
YV
Yvonne
1 year ago
Yeah, option D does seem risky. B sounds like the safer choice.
VA
Valentine
1 year ago
But Google recommends having primary and standby instances in different zones for high availability, so I still think option A is the way to go.
LA
Lajuana
1 year ago
D is a no-go. Putting all the instances in the same zone defeats the purpose of high availability. I agree with B - that's the simplest and most effective solution.
PO
Polly
1 year ago
D) Configure the primary, standby, and read replica instances in zone A, all in the same region.
CA
Catina
1 year ago
B) Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
MA
Marsha
1 year ago
A) Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
NO
Noel
2 years ago
Option C seems like overkill to me. Why spread the instances across multiple regions when you can get high availability within a single region? I'd go with option B.
JA
Jaclyn
1 year ago
Let's go with option B then. It's the most practical choice.
GI
Gilma
1 year ago
That's a good point. Option B does provide high availability within the same region.
GL
Glory
1 year ago
But wouldn't it be safer to have them in different zones within the same region?
JO
Johnna
1 year ago
I agree, spreading across multiple regions seems unnecessary.
GE
Gerry
2 years ago
I disagree, I believe option B is the best choice.
AS
Ashanti
2 years ago
I think option B is the way to go. Keeping the primary and standby in the same region ensures low latency, while the read replica in a different zone provides some geographic diversity.
RI
Ricarda
1 year ago
I think we should go with option C then, to ensure our database is highly available across different regions.
AD
Adelina
1 year ago
That's a good point, maybe option C would be the best choice for maximum high availability.
MI
Mignon
1 year ago
But wouldn't it be better to have the read replica in a different region for even more redundancy?
KA
Katie
1 year ago
I agree, option B sounds like a good balance between low latency and geographic diversity.
DE
Detra
1 year ago
In that case, option B might be the best compromise for our setup.
JO
Joana
1 year ago
That's true, but having the primary and standby in the same region can help with failover scenarios.
UL
Ula
1 year ago
But wouldn't it be better to spread the instances across different regions for better high availability?
JA
Janine
1 year ago
I agree, option B seems like a good balance between low latency and geographic diversity.
VA
Valentine
2 years ago
I think we should go with option A.