Hard1 markMultiple Choice
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?

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
Use Database Migration Service to replicate MySQL to Cloud SQL in an EU region, then cut over.
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.

Practice the full GCP Professional Cloud Architect Practice Exam 2

50 questions · hints · full answers · grading

More questions from this exam