Google Cloud Professional Cloud Database Engineer — Question 114

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?

Answer options

• A. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
• B. Use sharded Cloud SQL instances with one or more stores per database instance.
• C. Use a Biglable cluster with autoscaling.
• D. Use Cloud Spanner with a custom autoscaling solution.

Correct answer: D

Explanation

The correct answer is D because Cloud Spanner is designed for horizontal scaling and can handle the demands of a growing inventory system while minimizing disruption. Option A is less suitable for gradual rollouts due to its complexity and cost. Option B may not efficiently manage the scale and could lead to complications during the rollout. Option C, while effective for certain use cases, does not provide the same level of scalability and management features that Cloud Spanner offers.