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?

AUse Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

BUse sharded Cloud SQL instances with one or more stores per database instance.

CUse a Biglable cluster with autoscaling.

DUse Cloud Spanner with a custom autoscaling solution.

Show Suggested 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:

Submit Cancel

Lai

6 months ago

Not sure about Cloud Spanner, it might complicate things too much.

upvoted 0 times

...

Cory

6 months ago

Bigtable with autoscaling sounds interesting, but is it reliable enough?

upvoted 0 times

...

Georgiann

6 months ago

Wait, are we really considering Oracle RAC? Seems overkill for this.

upvoted 0 times

...

Linwood

7 months ago

Totally agree, it scales well with multiple stores!

upvoted 0 times

...

Rikki

7 months ago

I think sharded Cloud SQL is the way to go for cost efficiency.

upvoted 0 times

...

Chau

7 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

7 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

7 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

8 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

8 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

8 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

8 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

8 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

8 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

11 months ago

D) Cloud Spanner with a custom autoscaling solution could work well too.

upvoted 0 times

...

Jospeh

11 months ago

C) Use a Bigtable cluster with autoscaling.

upvoted 0 times

...

Clay

11 months ago

B) That sounds like a solid option for a gradual rollout.

upvoted 0 times

...

Alba

11 months 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

11 months ago

True, that could be a good option for minimizing costs and user disruption during regional rollouts.

upvoted 0 times

...

Reena

11 months ago

I think using Cloud Spanner with a custom autoscaling solution could also work well.

upvoted 0 times

...

Georgiana

12 months ago

C) Agreed, it's important to have a system that can scale up or down easily without causing disruptions.

upvoted 0 times

...

Pansy

12 months ago

Agreed, it's easy to scale up or down and automate for nights and holidays.

upvoted 0 times

...

Felicidad

12 months 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