Google Exam Professional Cloud Database Engineer 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, 01: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

Rikki

5 days ago

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

upvoted 0 times

...

Chau

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

16 days 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

22 days 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

28 days 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

28 days 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

28 days 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

28 days 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

28 days 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

1 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

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

4 months ago

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

upvoted 0 times

...

Jospeh

4 months ago

C) Use a Bigtable cluster with autoscaling.

upvoted 0 times

...

Clay

4 months ago

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

upvoted 0 times

...

Alba

4 months ago

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

upvoted 0 times

...

Herman

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

5 months ago

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

upvoted 0 times

...

Reena

5 months ago

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

upvoted 0 times

...

Georgiana

5 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

5 months ago

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

upvoted 0 times

...

Felicidad

5 months ago

Sharded Cloud SQL is definitely the way to go.

upvoted 0 times

...

Leslee

6 months ago

B) Definitely, sharded Cloud SQL is the best option for this scenario.

upvoted 0 times

...

Ramonita

6 months ago

A) Use sharded Cloud SQL instances with one or more stores per database instance.

upvoted 0 times

...

Karl

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

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

6 months ago

B) I agree, that seems like a more cost-effective and scalable solution for this project.

upvoted 0 times

...

Sanda

6 months ago

A) Use sharded Cloud SQL instances with one or more stores per database instance.

upvoted 0 times

...

Lashunda

7 months ago

That's a valid point, Martha. We should consider the cost implications as well before making a decision.

upvoted 0 times

...

Lajuana

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