PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #116
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…
The correct answer is D. Use Cloud Spanner with a custom autoscaling solution. The correct answer is D. Cloud Spanner is a fully managed, horizontally scalable, globally distributed SQL database that can handle 200 stores with 500 GB each (100 TB total) while supporting elastic scaling up or down - critical for nights and holidays. A custom autoscaling…
Question
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?
Options
- 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.
How the community answered
(51 responses)- A14% (7)
- B8% (4)
- C33% (17)
- D45% (23)
Explanation
The correct answer is D. Cloud Spanner is a fully managed, horizontally scalable, globally distributed SQL database that can handle 200 stores with 500 GB each (100 TB total) while supporting elastic scaling up or down - critical for nights and holidays. A custom autoscaling solution (such as the open-source Cloud Spanner Autoscaler) further refines cost efficiency. Option B (sharded Cloud SQL) introduces significant operational complexity, manual shard management, and is harder to scale dynamically. Option A (Oracle RAC on Bare Metal) is expensive, operationally heavy, and doesn't offer easy elastic scaling. Option C (Bigtable) is a NoSQL database and does not satisfy the SQL architecture requirement stated in the question.
Topics
Community Discussion
No community discussion yet for this question.