GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #116
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #116: Real Exam Question with Answer & Explanation
The correct answer is D: Use Cloud Spanner with a custom autoscaling solution.. https://cloud.google.com/spanner/docs/autoscaling-overview
Designing and Implementing Database Solutions
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.
Explanation
Topics
#Database Design#Cloud Spanner#Scalability#Cost Optimization
Community Discussion
No community discussion yet for this question.