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 store
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
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.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.