Discuss Google Professional Cloud Database Engineer Exam Topic 14 Question 58

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?

AUse linear scaling to implement the Autoscaler-based architecture

BUse direct scaling to implement the Autoscaler-based architecture.

CUpgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

DSet up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

Suggested Answer: A

Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing units required to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount. https://cloud.google.com/spanner/docs/autoscaling-overview#linear

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

32 comments · newest first

Latanya 10 months ago

Wait, are we really considering D? That seems risky!

Berry 10 months ago

C sounds too manual for my taste.

Makeda 10 months ago

A is the way to go for scaling!

Bernadine 11 months ago

Autoscaler is essential for handling those holiday spikes!

Glory 11 months ago

I disagree, B might be more efficient.

Elke 11 months ago

I vaguely remember that upgrading during maintenance windows could lead to downtime, so I’m hesitant about option C. It feels risky for consumer services.

Maybelle 11 months ago

I lean towards option D because setting up alerts seems proactive, but I wonder if it’s the most efficient way to handle spikes in traffic.

Jerry 11 months ago

I think we practiced a similar question where we had to choose between scaling methods. I feel like the Autoscaler-based architecture is key, but I can't recall the specifics.

Ula 12 months ago

I remember studying about Cloud Spanner's scaling options, but I'm not sure if linear or direct scaling is the right choice here.

Alexis 12 months ago

Based on the details provided, I think the best approach is to use linear scaling to implement the Autoscaler-based architecture. That way, the system can automatically scale up as needed to handle the increased traffic.

Ashton 1 year ago

Upgrading the Cloud Spanner instance on a periodic basis could work, but it might not be the most efficient approach if the traffic volume is constantly increasing. I'd prefer a more dynamic solution.

Marleen 1 year ago

The question mentions needing to support a higher level of concurrency, so I'm leaning towards the option that involves setting up alerts and scheduling upgrades during maintenance windows.

Tenesha 1 year ago

Hmm, I'm a bit confused about the differences between linear and direct scaling. I'll need to review that part of the material again before deciding.

Erick 1 year ago

This question seems straightforward. I think the key is to use the Autoscaler-based architecture to automatically scale the Cloud Spanner instance as needed.

Nichelle 1 year ago

Option A is the clear winner here. Linear scaling? That's my middle name!

Geraldine 1 year ago

Hmm, I dunno, these database options are making my head spin. Can we just use a spreadsheet instead?

Ceola 1 year ago

That's a good point, we should consider both options before making a decision.

Melita 1 year ago

Direct scaling might be faster, but linear scaling provides more flexibility for our traffic spikes.

Glendora 1 year ago

I'm not sure, maybe direct scaling could be more efficient in our case.

Ceola 1 year ago

I agree with Melita, linear scaling would be the best option for our needs.

Melita 1 year ago

I think we should use linear scaling with Autoscaler-based architecture.

Elfriede 1 year ago

I'm all for option B. Direct scaling is where it's at! No need to get fancy with Autoscaler-based stuff.

Rolland 1 year ago

↳ replying to Elfriede

User 2: Yeah, direct scaling seems like the simpler and more efficient choice.

Sue 1 year ago

↳ replying to Elfriede

User 1: I think we should go with option B for direct scaling.

Lorean 1 year ago

D sounds good, but I'm a bit concerned about the scheduled maintenance window. What if we need to scale up during off-hours?

Twana 1 year ago

↳ replying to Lorean

C) Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

Miesha 1 year ago

↳ replying to Lorean

B) Use direct scaling to implement the Autoscaler-based architecture.

Gail 1 year ago

↳ replying to Lorean

A) Use linear scaling to implement the Autoscaler-based architecture

Marcos 1 year ago

Autoscaler is the way to go! Less manual work and more automation, that's what I like to see.

Tawanna 1 year ago

↳ replying to Marcos

D) Setting up alerts for utilization metrics is a good proactive approach

Lacey 1 year ago

↳ replying to Marcos

B) I agree, using Autoscaler will definitely help with the automation

Shanda 1 year ago

↳ replying to Marcos

A) Use linear scaling to implement the Autoscaler-based architecture

Google Professional Cloud Database Engineer Exam - Topic 14 Question 58 Discussion