ExpertMinds LogoExpertMinds
Hard1 markMultiple Choice
Subtask 1.2: Technical RequirementsDatabaseCloud SQLDatabase Migration ServiceCase Study
This question is part of a case study — click to read the full scenario(Case 01)

CASE STUDY: TechStream Gaming

Overview:
Industry: Gaming
Size: 500 employees, $100M revenue

Environment:

  • On-prem US/EU
  • 200 servers
  • MySQL (5 TB)
  • 2M peak users
  • $100K/mo cost

Requirements:

  • Reduce costs 40%
  • 5x growth
  • Launch APAC/SA/Africa
  • Daily deployments

Exec Statements:

  • CEO: Scale rapidly.
  • CFO: Max $100K/mo, 18mo ROI.
  • CTO: Limited cloud exp, 99.95% uptime.

Tech Reqs:

  • <100ms latency globally
  • Real-time analytics
  • 5x seasonal spikes
  • EU data residency
  • DDoS protection
  • CI/CD

Constraints:

  • 12mo migration
  • <4hr downtime
  • 20 Java/MySQL devs, 5 ops
  • $2M budget

QUESTION: Based on the constraints and requirements, which migration strategy should you recommend for the core gaming application?

View full case study page →

GCP PCA · Question 03 · Technical Requirements

CASE STUDY: TechStream Gaming

Overview:
Industry: Gaming
Size: 500 employees, $100M revenue

Environment:

  • On-prem US/EU
  • 200 servers
  • MySQL (5 TB)
  • 2M peak users
  • $100K/mo cost

Requirements:

  • Reduce costs 40%
  • 5x growth
  • Launch APAC/SA/Africa
  • Daily deployments

Exec Statements:

  • CEO: Scale rapidly.
  • CFO: Max $100K/mo, 18mo ROI.
  • CTO: Limited cloud exp, 99.95% uptime.

Tech Reqs:

  • <100ms latency globally
  • Real-time analytics
  • 5x seasonal spikes
  • EU data residency
  • DDoS protection
  • CI/CD

Constraints:

  • 12mo migration
  • <4hr downtime
  • 20 Java/MySQL devs, 5 ops
  • $2M budget

QUESTION: Which database architecture should you recommend to replace the 5TB MySQL database while meeting the <4-hour downtime constraint?

Answer options:

A.

Migrate to Cloud Spanner using Dataflow for a one-time batch load during the maintenance window.

B.

Migrate to Cloud SQL for MySQL using Database Migration Service (DMS) for continuous replication before cutover.

C.

Migrate to BigQuery using Storage Transfer Service to handle the 5TB of data.

D.

Deploy MySQL on Compute Engine instances and use rsync to synchronize the data.

How to approach this question

Look for a solution that minimizes downtime (continuous replication) and matches the team's current skill set (MySQL).

Full Answer

B.Migrate to Cloud SQL for MySQL using Database Migration Service (DMS) for continuous replication before cutover.✓ Correct
Migrate to Cloud SQL for MySQL using Database Migration Service (DMS) for continuous replication before cutover.
Database Migration Service (DMS) provides continuous replication from the source MySQL database to Cloud SQL. This ensures the databases are in sync, allowing for a rapid cutover that easily meets the <4-hour downtime requirement. Cloud SQL is fully managed, helping the small ops team.

Common mistakes

Choosing Spanner (A) because it's the 'global' database, ignoring the massive refactoring required to move from MySQL to Spanner within the constraints.
02All questions04

Practice the full GCP Professional Cloud Architect Practice Exam 6

50 questions · hints · full answers · grading

Sign up freeTake the exam

More questions from this exam

Q01CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...MediumQ02CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...MediumQ04CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...MediumQ05CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...EasyQ06CASE STUDY: RetailMart Overview: Industry: Retail/E-commerce Size: 2000 employees, $500M revenue...Hard
View all 50 questions →