Google Professional Cloud Database Engineer Exam - Topic 9 Question 48 Discussion

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

Question #: 48
Topic #: 9

[All Professional Cloud Database Engineer Questions]

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

APlace the bulk of the read and write workloads closer to the default leader region.

BUse staleness of at least 15 seconds.

CAdd more read-write replicas.

DKeep the total CPU utilization under 45% in each region.

Show Suggested Answer

Suggested Answer: A

https://cloud.google.com/spanner/docs/instance-configurations#multi-region-best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.

by Launa at Nov 14, 2024, 01:04 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

Chantell

6 days ago

Totally agree, proximity matters!

upvoted 0 times

...

Ronnie

12 days ago

A seems like the best option to reduce latency.

upvoted 0 times

...

Hassie

17 days ago

Keeping CPU utilization under 45% seems like a good practice, but I doubt it would directly address the write performance issue we're facing.

upvoted 0 times

...

Rashida

23 days ago

Adding more read-write replicas sounds familiar, but I’m not clear on how much that would actually speed things up in a multi-regional setup.

upvoted 0 times

...

Hassie

28 days ago

I think using staleness might be a good idea, especially since it can reduce the load on the system. I saw a similar question about read consistency in our practice tests.

upvoted 0 times

...

Ty

1 month ago

I remember something about placing workloads closer to the leader region could help with performance, but I'm not entirely sure if that's the best option here.

upvoted 0 times

...

Shawnna

1 month ago

Ah, I see what they're getting at. If the write workloads are slow in the multi-regional instance, then we need to find a way to make them faster. Using staleness of at least 15 seconds could be a good way to optimize performance, but I'd want to understand the implications of that approach.

upvoted 0 times

...

Cordie

1 month ago

I'm a bit confused on this one. The options seem to be focused on different strategies, but I'm not sure which one would be the most effective. Maybe I should re-read the question and think about the tradeoffs of each approach.

upvoted 0 times

...

Deeanna

1 month ago

Okay, let me think this through. The question says the write workloads are slow in the multi-regional instance, so I'm guessing we need to find a way to improve that. Placing the workloads closer to the default leader region could be a good approach.

upvoted 0 times

...

Willard

1 month ago

Hmm, this is an interesting one. I think the key is to figure out how to optimize the write workloads in the multi-regional instance. Maybe adding more read-write replicas could help distribute the load?

upvoted 0 times

...

Gladys

11 months ago

I think we should also consider placing the bulk of the read and write workloads closer to the default leader region to optimize performance.

upvoted 0 times

...

Josefa

12 months ago

Option A sounds promising. Placing the workloads closer to the default leader region could reduce latency and improve write performance.

upvoted 0 times

...

Gary

12 months ago

I agree with Toi. Adding more read-write replicas can help distribute the workload and improve performance.

upvoted 0 times

...

Toi

12 months ago

I think we should add more read-write replicas to make the write workloads faster.

upvoted 0 times

...

Louis

12 months ago

Haha, keep the total CPU utilization under 45%? That's like asking a cheetah to run at the speed of a sloth. Good one, Option D!

upvoted 0 times

Loren

11 months ago

Yeah, keeping the CPU under 45% seems like a tough task. Option D might be the best bet.

upvoted 0 times

...

Stephen

11 months ago

I think adding more read-write replicas could also help distribute the workload.

upvoted 0 times

...

Maryann

11 months ago

Option D is definitely a good one. We need to keep the CPU utilization in check.

upvoted 0 times

...

Cammy

11 months ago

Yeah, placing the bulk of the read and write workloads closer to the default leader region could also be a good solution.

upvoted 0 times

...

Georgiana

11 months ago

Maybe adding more read-write replicas would help speed up the write workloads.

upvoted 0 times

...

Margurite

11 months ago

I agree, keeping CPU utilization under 45% seems impossible.

upvoted 0 times

...

Lisbeth

12 months ago

Option D is definitely not realistic in a write-heavy application.

upvoted 0 times

...

Malissa

1 year ago

I'm not sure about that. Wouldn't increasing the staleness to 15 seconds (Option B) be a simpler solution to improve write performance?

upvoted 0 times

...

Elli

1 year ago

Option C seems like the way to go. Adding more read-write replicas should help distribute the workload and improve overall performance in a multi-regional instance.

upvoted 0 times