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

Martha

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

3 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

...