Q: **CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming company with 500 employees and $50M annual revenue. **Current Environment:** On-premises data centers in US and EU. 200 servers. MySQL databases (5 TB). Peak users: 2M. Cost: $100K/mo. **Business Requirements:** Reduce costs by 40%. Support 5x user growth. Launch in APAC, SA, Africa. Improve deployment to daily. **Executive Statements:** CEO: 'Scale rapidly.' CFO: 'Max $100K/mo, ROI 18mo.' CTO: 'Limited cloud exp, 99.95% uptime.' **Technical Requirements:** <100ms latency globally. Real-time analytics. 5x traffic spikes. EU data residency. DDoS protection. CI/CD. **Constraints:** 12-month migration. Max 4-hour downtime. 20 devs (Java/MySQL), 5 ops (limited cloud). Budget $2M. **QUESTION:** Which database solution should you recommend to replace the 5 TB MySQL databases, considering the need for global expansion, strong consistency for game state, and EU data residency?

Look for a database that supports relational data (migrating from MySQL), global scale (5x growth, new regions), and strong consistency.

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

Choosing Cloud SQL (won't scale horizontally for writes globally) or Bigtable (not relational, lacks ACID transactions for complex game state).

Question 1

**CASE STUDY: TechStream Gaming**

**Company Overview:** TechStream Gaming is a global gaming company with 500 employees and $50M annual revenue.
**Current Environment:** On-premises data centers in US and EU. 200 servers. MySQL databases (5 TB). Peak users: 2M. Cost: $100K/mo.
**Business Requirements:** Reduce costs by 40%. Support 5x user growth. Launch in APAC, SA, Africa. Improve deployment to daily.
**Executive Statements:** CEO: 'Scale rapidly.' CFO: 'Max $100K/mo, ROI 18mo.' CTO: 'Limited cloud exp, 99.95% uptime.'
**Technical Requirements:** <100ms latency globally. Real-time analytics. 5x traffic spikes. EU data residency. DDoS protection. CI/CD.
**Constraints:** 12-month migration. Max 4-hour downtime. 20 devs (Java/MySQL), 5 ops (limited cloud). Budget $2M.

**QUESTION:**
Which database solution should you recommend to replace the 5 TB MySQL databases, considering the need for global expansion, strong consistency for game state, and EU data residency?

Accepted Answer

Look for a database that supports relational data (migrating from MySQL), global scale (5x growth, new regions), and strong consistency.

Question 2

What mistakes do candidates make on this GCP PCA question?

Accepted Answer

Choosing Cloud SQL (won't scale horizontally for writes globally) or Bigtable (not relational, lacks ACID transactions for complex game state).

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Professional Cloud Architect Practice Exam 1

More questions from this exam