Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - 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 Professional Cloud Database Engineer Exam - Topic 2 Question 47 Discussion

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
C) Use a Biglable cluster with autoscaling.
A) Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
B) Use sharded Cloud SQL instances with one or more stores per database instance.
D) Use Cloud Spanner with a custom autoscaling solution.

Google Professional Cloud Database Engineer Exam - Topic 2 Question 47 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 47
Topic #: 2
[All Professional Cloud Database Engineer Questions]

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat

a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Teddy at Oct 24, 2024, 12:22 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lai
9 months ago
Not sure about Cloud Spanner, it might complicate things too much.
upvoted 0 times
...
Cory
9 months ago
Bigtable with autoscaling sounds interesting, but is it reliable enough?
upvoted 0 times
...
Georgiann
10 months ago
Wait, are we really considering Oracle RAC? Seems overkill for this.
upvoted 0 times
...
Linwood
10 months ago
Totally agree, it scales well with multiple stores!
upvoted 0 times
...
Rikki
10 months ago
I think sharded Cloud SQL is the way to go for cost efficiency.
upvoted 0 times
...
Chau
10 months ago
I recall that Oracle RAC can be complex and might not be the best for gradual rollouts. I wonder if that would cause more disruption than necessary.
upvoted 0 times
...
Clorinda
11 months ago
I practiced a similar question about database architecture, and I feel like Cloud Spanner might be the best choice for scalability, but I’m unsure about the custom autoscaling part.
upvoted 0 times
...
Ty
11 months ago
I think using sharded Cloud SQL instances could help with scaling, but I’m not entirely confident about how that would work with 200 stores.
upvoted 0 times
...
Izetta
11 months ago
I remember we discussed the importance of minimizing costs during rollouts, but I'm not sure which option would be the most cost-effective.
upvoted 0 times
...
Lorenza
11 months ago
I'm a bit lost on this one. There are a lot of factors to consider, and I'm not sure I fully understand the implications of each solution. I'll need to review the material again before attempting this.
upvoted 0 times
...
Alana
11 months ago
This is a great question that really tests our understanding of database architectures. I'm confident I can work through the tradeoffs and select the best option.
upvoted 0 times
...
Ammie
11 months ago
Okay, I think I have a strategy here. The key is finding a database solution that can scale up and down easily to handle the varying load across days and holidays. I'm leaning towards option B or D.
upvoted 0 times
...
Ashton
11 months ago
Hmm, I'm a bit unsure about this one. The details around the 200 stores and 500 GB of data per store seem important, but I'm not sure which option best addresses those specifics.
upvoted 0 times
...
Janey
11 months ago
This looks like a tricky database design question. I'll need to carefully consider the requirements around cost, scalability, and minimizing user disruption.
upvoted 0 times
...
Herman
1 year ago
You know, if this was the Dark Ages, they'd probably just use a quill and parchment for the inventory. No databases, no problems!
upvoted 0 times
Nu
1 year ago
D) Cloud Spanner with a custom autoscaling solution could work well too.
upvoted 0 times
...
Jospeh
1 year ago
C) Use a Bigtable cluster with autoscaling.
upvoted 0 times
...
Clay
1 year ago
B) That sounds like a solid option for a gradual rollout.
upvoted 0 times
...
Alba
1 year ago
A) Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
upvoted 0 times
...
...
Herman
1 year ago
Sharded Cloud SQL is definitely the way to go. Easy to scale up or down, and you can even automate it for nights and holidays. Wouldn't want the store managers calling me at 3 AM because the system crashed, you know?
upvoted 0 times
Carman
1 year ago
True, that could be a good option for minimizing costs and user disruption during regional rollouts.
upvoted 0 times
...
Reena
1 year ago
I think using Cloud Spanner with a custom autoscaling solution could also work well.
upvoted 0 times
...
Georgiana
1 year ago
C) Agreed, it's important to have a system that can scale up or down easily without causing disruptions.
upvoted 0 times
...
Pansy
1 year ago
Agreed, it's easy to scale up or down and automate for nights and holidays.
upvoted 0 times
...
Felicidad
1 year ago
Sharded Cloud SQL is definitely the way to go.
upvoted 0 times
...
Leslee
1 year ago
B) Definitely, sharded Cloud SQL is the best option for this scenario.
upvoted 0 times
...
Ramonita
1 year ago
A) Use sharded Cloud SQL instances with one or more stores per database instance.
upvoted 0 times
...
...
Karl
1 year ago
Cloud Spanner, huh? That could work, but I bet it'd cost an arm and a leg. I'd stick with the good old sharded Cloud SQL - it's tried and true.
upvoted 0 times
...
Gayla
1 year ago
Bigdata solution like Bigtable? Nah, this is a fairly simple inventory management system, no need for that kind of heavy-duty stuff.
upvoted 0 times
Corinne
1 year ago
B) I agree, that seems like a more cost-effective and scalable solution for this project.
upvoted 0 times
...
Sanda
1 year ago
A) Use sharded Cloud SQL instances with one or more stores per database instance.
upvoted 0 times
...
...
Lashunda
1 year ago
That's a valid point, Martha. We should consider the cost implications as well before making a decision.
upvoted 0 times
...
Lajuana
1 year ago
Hmm, Oracle RAC on Bare Metal seems like overkill for this scenario. I'd go with the sharded Cloud SQL instances to keep things scalable and cost-effective.
upvoted 0 times
Orville
1 year ago
Cloud Spanner with a custom autoscaling solution might be worth considering as well.
upvoted 0 times
...
Felix
1 year ago
I think using a Bigtable cluster with autoscaling could also be a good option.
upvoted 0 times
...
Brent
1 year ago
Sharded Cloud SQL instances would definitely be more cost-effective and scalable.
upvoted 0 times
...
Santos
1 year ago
I agree, Oracle RAC on Bare Metal does seem like overkill.
upvoted 0 times
...
...
Martha
1 year ago
I disagree, I believe option B, using sharded Cloud SQL instances, would be more cost-effective and efficient for our needs.
upvoted 0 times
...
Lashunda
1 year ago
I think we should go with option D, Cloud Spanner with a custom autoscaling solution. It will allow us to scale up or down easily.
upvoted 0 times
...

Save Cancel