Medium1 markMultiple Choice

Subtask 1.2: Technical RequirementsDatabaseCloud SQLMigrationCase Study

This question is part of a case study — click to read the full scenario(Case 01)

CASE STUDY: TechStream Gaming
Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem servers (US/EU), MySQL 5TB. 2M peak users. $150K/mo cost.
Business Req: Reduce cost 40%, 5x growth, 3 new regions, daily deployments.
Execs: CEO wants scale; CFO caps budget at $100K/mo; CTO needs 99.95% uptime, notes team has limited cloud skills.
Tech Req: <100ms global latency, real-time analytics, 5x seasonal spikes, EU data residency, DDoS protection.
Constraints: 12-month migration, max 4-hour downtime.

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

View full case study page →

GCP PCA · Question 03 · Technical Requirements

CASE STUDY: TechStream Gaming
Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem servers (US/EU), MySQL 5TB. 2M peak users. $150K/mo cost.
Business Req: Reduce cost 40%, 5x growth, 3 new regions, daily deployments.
Execs: CEO wants scale; CFO caps budget at $100K/mo; CTO needs 99.95% uptime, notes team has limited cloud skills.
Tech Req: <100ms global latency, real-time analytics, 5x seasonal spikes, EU data residency, DDoS protection.
Constraints: 12-month migration, max 4-hour downtime.

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

Q: CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem servers (US/EU), MySQL 5TB. 2M peak users. $150K/mo cost. Business Req: Reduce cost 40%, 5x growth, 3 new regions, daily deployments. Execs: CEO wants scale; CFO caps budget at $100K/mo; CTO needs 99.95% uptime, notes team has limited cloud skills. Tech Req: <100ms global latency, real-time analytics, 5x seasonal spikes, EU data residency, DDoS protection. Constraints: 12-month migration, max 4-hour downtime. QUESTION: Which database migration strategy meets the 4-hour downtime constraint and EU data residency requirement?

Match the constraints (4-hour downtime = continuous replication needed) and requirements (EU residency = EU region).

Q: What mistakes do candidates make on this GCP PCA question?

Choosing export/import (A), which is too slow for 5TB within a 4-hour window.

Answer options:

Export MySQL dumps, transfer via Cloud Storage, and import to Cloud Spanner in the US.

Use Database Migration Service (DMS) to continuously replicate to Cloud SQL for MySQL in an EU region, then perform a brief cutover.

Set up a VPN and configure the on-premises application to write directly to Cloud SQL in the EU.

Migrate the database to BigQuery using Dataflow to support real-time analytics.

How to approach this question

Match the constraints (4-hour downtime = continuous replication needed) and requirements (EU residency = EU region).

Full Answer

B.Use Database Migration Service (DMS) to continuously replicate to Cloud SQL for MySQL in an EU region, then perform a brief cutover.✓ Correct

Use Database Migration Service (DMS) to replicate MySQL to Cloud SQL for MySQL in an EU region, then cut over.

Database Migration Service (DMS) allows for continuous data replication from on-premises to Cloud SQL. This means the initial 5TB sync happens while the app is live, and downtime is only required to switch the connection string.

Common mistakes

Choosing export/import (A), which is too slow for 5TB within a 4-hour window.

Question 02 All questions Question 04

Practice the full GCP Professional Cloud Architect Practice Exam 5

50 questions · hints · full answers · grading

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Professional Cloud Architect Practice Exam 5

More questions from this exam