Google Exam Professional Cloud Database Engineer Topic 12 Question 22 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 22
Topic #: 12

[All Professional Cloud Database Engineer Questions]

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

AUse Cloud SQL with cross-region replicas.

BUse high availability (HA) Cloud SQL with multiple zones.

CUse zonal Cloud SQL without high availability (HA).

DUse Cloud Spanner in a regional configuration.

Show Suggested Answer

Suggested Answer: D

https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

by Francine at Nov 23, 2023, 09:03 AM

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

Christene

7 months ago

Hah, I bet the exam folks are trying to trick us with this one! They're probably hoping we'll go for the zonal Cloud SQL without HA and then be like, 'Nope, that's not gonna cut it for write latency.' I'm with you guys on the HA Cloud SQL or the regional Cloud Spanner. Gotta keep that write latency low, ya know?

upvoted 0 times

...

Ahmed

7 months ago

Hmm, this is a tough one. I was initially thinking the regional Cloud Spanner might be the way to go, but then I remembered that it's a managed service, so the high availability Cloud SQL might be a safer bet. Although, the multiple zones could add some complexity...

upvoted 0 times

...

Christiane

7 months ago

I agree, the focus on write latency is the crucial factor here. I'm not sure I'd go with the cross-region replicas in Cloud SQL, as that might introduce more network latency. The zonal Cloud SQL without HA seems a bit risky to me, so I'd probably go with either the HA Cloud SQL or the regional Cloud Spanner.

upvoted 0 times

...

Tomas

7 months ago

Hmm, this is a tricky one. I think the key here is to minimize write latency, so I'm leaning towards either option B or D. The high availability Cloud SQL with multiple zones could help distribute the load and reduce latency, but Cloud Spanner in a regional configuration might also do the trick.

upvoted 0 times

Rashad

7 months ago

D) Use Cloud Spanner in a regional configuration.

upvoted 0 times

...

Felicitas

7 months ago

B) Use high availability (HA) Cloud SQL with multiple zones.

upvoted 0 times

...