ExpertMinds LogoExpertMinds
Hard1 markMultiple Choice
Domain 1: Designing and Planning a Cloud Solution ArchitectureCloud SpannerDatabase MigrationHigh Availability
This question is part of a case study — click to read the full scenario(Case 01)

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 migration strategy should you recommend for the core gaming application to meet the business and technical requirements?

View full case study page →

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?

Answer options:

A.

Migrate to Cloud SQL for MySQL using a one-time SQL dump and restore.

B.

Migrate to Cloud Bigtable to handle the 5x growth.

C.

Migrate to Cloud Spanner using Database Migration Service (DMS) or custom replication to minimize downtime.

D.

Migrate to Firestore in Datastore mode.

How to approach this question

Identify the need for 'global scale' + 'relational consistency'. Only one GCP database does both.

Full Answer

C.Migrate to Cloud Spanner using Database Migration Service (DMS) or custom replication to minimize downtime.✓ Correct
Migrate to Cloud Spanner using Database Migration Service (DMS) or custom replication to minimize downtime.
Cloud Spanner is Google Cloud's fully managed, horizontally scalable relational database. It provides strong global consistency, which is required for gaming state, while scaling to handle the 5x growth. To meet the 4-hour downtime constraint, a continuous replication strategy (like Datastream or custom CDC) must be used prior to the final cutover.

Common mistakes

Choosing Cloud SQL (A) - it is limited to regional high availability and vertical scaling, which will bottleneck with 5x global growth.
03All questions05

Practice the full GCP Professional Cloud Architect Practice Exam 4

50 questions · hints · full answers · grading

Sign up freeTake the exam

More questions from this exam

Q01CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...MediumQ02CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...MediumQ03CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...HardQ05CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...EasyQ06CASE STUDY: RetailMart Overview: Global e-commerce, 5,000 employees. Legacy monolith on VMware, ...Medium
View all 50 questions →