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 2Question 03
    Hard1 markMultiple Choice
    Domain 1: Designing and Planning a Cloud Solution ArchitectureDatabaseMigrationCloud SQL
    This question is part of a case study — click to read the full scenario(Case 01)

    CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak users. $100K/mo cost. Req: Cut cost 40%, 5x growth, 3 new regions, daily deploys. CEO: Scale fast. CFO: <$100K/mo, 18mo ROI. CTO: Low cloud skills, 99.95% uptime. Tech: <100ms latency, real-time analytics, 5x spikes, EU data residency, DDoS protection, CI/CD. Constraints: 12mo migration, 4hr downtime, 20 devs (Java/MySQL), 5 ops (no cloud), $2M budget.

    Which migration strategy should you recommend for the legacy monolithic application to meet the 12-month timeline and team skill constraints?

    View full case study page →

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

    CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak users. $100K/mo cost. Req: Cut cost 40%, 5x growth, 3 new regions, daily deploys. CEO: Scale fast. CFO: <$100K/mo, 18mo ROI. CTO: Low cloud skills, 99.95% uptime. Tech: <100ms latency, real-time analytics, 5x spikes, EU data residency, DDoS protection, CI/CD. Constraints: 12mo migration, 4hr downtime, 20 devs (Java/MySQL), 5 ops (no cloud), $2M budget.

    Which database migration strategy meets the 4-hour downtime constraint and EU data residency requirement?

    Answer options:

    A.

    Export MySQL to Cloud Storage, then import to Cloud SQL.

    B.

    Use Database Migration Service to replicate to Cloud SQL in an EU region.

    C.

    Migrate to global Cloud Spanner using Dataflow.

    D.

    Use Transfer Appliance to ship the 5TB database to a US region.

    How to approach this question

    Identify minimal downtime migration tools for MySQL.

    Full Answer

    B.Use Database Migration Service to replicate to Cloud SQL in an EU region.✓ Correct
    Database Migration Service (DMS) enables continuous replication from on-prem MySQL to Cloud SQL, ensuring cutover takes minutes, well under 4 hours.

    Common mistakes

    Choosing export/import which is too slow for 5TB.
    Question 02All questionsQuestion 04

    Practice the full GCP Professional Cloud Architect Practice Exam 2

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ02CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ04CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ05CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...EasyQ06CASE STUDY: ShopGlobal. Global e-commerce. Monolithic Java on VMware. Oracle RAC (20TB). 10x Blac...Hard
    View all 50 questions →