GCP PCA · Question 04 · Domain 1: Designing and Planning a Cloud Solution Architecture

CASE STUDY: TechStream Gaming

Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers, 5TB MySQL. 2M peak users, $100K/mo cost.
Business: Reduce cost 40%, 5x growth, launch APAC/SA/Africa, daily deployments.
Executives:

• CEO: "Scale rapidly to compete. Cloud is critical."
• CFO: "Cost reduction paramount. Max $100K/mo. ROI in 18 months."
• CTO: "Team has limited cloud experience. 99.95% uptime non-negotiable."
  Tech: <100ms latency globally, real-time analytics, 5x seasonal spikes, EU data residency, DDoS protection, CI/CD.
  Constraints: 12-month migration, 4hr max downtime, 20 devs (Java/MySQL), 5 ops (limited cloud), $2M budget.

Which database solution should you recommend to replace the 5TB MySQL database, given the need for global scale, relational consistency, and the 4-hour downtime constraint?