For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeGCP Professional Cloud ArchitectGCP Professional Cloud Architect Practice Exam 6Question 03
    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
    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.
    Question 02All questionsQuestion 04

    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 →