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

Herman

21 hours 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

...

Karl

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

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

...

Lashunda

14 days ago

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

upvoted 0 times

...

Lajuana

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

...

Martha

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

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

...