Subtask 1.2: Technical Requirements

**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?

**CASE STUDY: TerramEarth** **Company Overview:** TerramEarth manufactures heavy equipment. 2 million vehicles in the field. **Current Environment:** Vehicles send telemetry via cellular. Processing 100,000 msgs/sec. On-prem Hadoop cluster. **Business Requirements:** Predict equipment failure. Reduce warranty costs. Provide fleet dashboard. **Executive Statements:** CEO: 'Monetize data.' CFO: 'Storage costs spiraling.' CTO: 'Need scalable ingestion and ML.' **Technical Requirements:** Ingest 500,000 msgs/sec. Store petabytes cost-effectively. Train ML models. Real-time anomaly detection. **Constraints:** Intermittent connectivity. Strict vehicle authentication. **QUESTION:** Which architecture should you design to handle the ingestion of 500,000 messages per second from vehicles with intermittent connectivity?

A startup is building a new stateless web application using Node.js. They want to deploy it to GCP with zero infrastructure management, automatic scaling from zero to handle unpredictable traffic, and pay only when the code is executing. Which compute service should you recommend?

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?

CASE STUDY: ShopGlobal Overview: Retailer, 2000 employees, $500M revenue. US-Central co-lo, Java/Tomcat monolith, Oracle RAC 20TB, batch inventory sync. Business Req: Handle 10x Black Friday spikes, personalized recommendations, modernize to microservices. Execs: CEO wants omnichannel; CFO needs predictable spend; CTO demands zero downtime cutover. Tech Req: PCI-DSS compliance, automated image processing, real-time inventory, CI/CD. Constraints: Complex Oracle stored procedures, team learning containers, strict bi-annual audits. QUESTION: How should you design the automated image processing pipeline for the product catalog?

A global financial institution is designing a new ledger system. The system requires strong relational consistency (ACID transactions), must scale horizontally to handle millions of transactions per second, and must provide 99.999% availability across multiple continents. Which database service should you recommend?

You are designing a highly available web application on Compute Engine. The application must survive a single zone failure without any manual intervention. Which TWO architectural components are required? (Select TWO)

You are designing a serverless data pipeline to ingest streaming clickstream data, transform it by enriching it with user profiles, and store it for complex SQL analysis. Which THREE GCP services should you combine for this architecture? (Select THREE)

Your data analytics team runs queries against a 100 TB BigQuery table containing 5 years of sales data. Most queries filter by the 'transaction_date' and group by 'store_id'. The queries are currently scanning the entire table, resulting in high costs and slow performance. Which TWO optimizations should you apply? (Select TWO)

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?

CASE STUDY: HealthData Inc Overview: Industry: Healthcare Analytics Size: 1000 employees Environment: - Co-located data center - Hadoop cluster - SFTP servers - 50 TB patient data Requirements: - ML models for diagnostics - Secure data sharing portals - Break data silos Exec Statements: - CEO: Need compute for ML. - CRO: HIPAA compliance is top priority. - CTO: Managed services needed to replace Hadoop. Tech Reqs: - Strict HIPAA compliance - Automated PHI de-identification - Comprehensive audit logging - CMEK - Network isolation (no public internet) Constraints: - US data sovereignty - 7-year retention (immutable) - Easy auditor access QUESTION: To replace the on-premises Hadoop cluster with a managed service while minimizing migration effort, which GCP service should you recommend?

CASE STUDY: ManuIoT Overview: Industry: Manufacturing Size: 100 factories globally Environment: - 100,000 sensors - Local SCADA - Fragmented SQL Server DBs - No central analytics Requirements: - Predictive maintenance - Real-time global dashboards - Edge computing Exec Statements: - CEO: Monetize telemetry. - CFO: Costs must scale linearly. - VP Ops: Factory lines need local control if internet drops. Tech Reqs: - Ingest 1M msgs/sec - Stream processing - Offline factory capabilities - Train ML centrally, deploy to edge Constraints: - Low bandwidth/high latency at factories - Legacy MQTT protocol - Zero IT staff at factories QUESTION: How should you architect the ingestion layer to handle 1 million MQTT messages per second from the legacy sensors?

A financial services company is designing a new global payment processing system. The system requires a relational database that provides strong consistency, horizontal scalability, and high availability across three continents. Which GCP database service should you recommend?

A development team wants to deploy a suite of event-driven microservices. They require a fully managed, serverless environment where they only pay for the exact compute time used (scaling to zero). Which TWO GCP compute services meet these requirements? (Select TWO)

CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game developer with 500 employees and $100M annual revenue. They recently launched a hit mobile game that is growing rapidly. Current Technical Environment: - On-premises data centers in US and EU. - 200 bare-metal servers running Linux. - Self-managed MySQL databases (5 TB total) for player profiles and inventory. - Peak concurrent users: 2 million. - Current monthly infrastructure cost: $150K. Business Requirements: - Reduce infrastructure costs by 40%. - Support 5x user growth over 2 years. - Launch in 3 new regions (APAC, SA, Africa). - Improve deployment speed from 1 week to daily. Executive Statements: - CEO: "We need to scale rapidly to compete. Cloud migration is critical." - CFO: "Cost reduction is paramount. We cannot exceed $100K/month. ROI must be achieved in 18 months." - CTO: "Our team has limited cloud experience. Reliability is non-negotiable - 99.95% uptime minimum." Technical Requirements: - Sub-100ms latency for players globally. - Real-time analytics on player behavior. - Seasonal traffic spikes (5x during holidays). - CI/CD pipeline for daily deployments. Constraints: - Migration must complete in 12 months. - Cannot exceed 4-hour downtime during cutover. - Dev team: 20 engineers (Java, MySQL). - Ops team: 5 engineers (limited cloud experience). QUESTION: Which database migration strategy should you recommend to meet the global scalability and latency requirements while minimizing operational overhead for the ops team?

CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game developer with 500 employees and $100M annual revenue. They recently launched a hit mobile game that is growing rapidly. Current Technical Environment: - On-premises data centers in US and EU. - 200 bare-metal servers running Linux. - Self-managed MySQL databases (5 TB total) for player profiles and inventory. - Peak concurrent users: 2 million. - Current monthly infrastructure cost: $150K. Business Requirements: - Reduce infrastructure costs by 40%. - Support 5x user growth over 2 years. - Launch in 3 new regions (APAC, SA, Africa). - Improve deployment speed from 1 week to daily. Executive Statements: - CEO: "We need to scale rapidly to compete. Cloud migration is critical." - CFO: "Cost reduction is paramount. We cannot exceed $100K/month. ROI must be achieved in 18 months." - CTO: "Our team has limited cloud experience. Reliability is non-negotiable - 99.95% uptime minimum." Technical Requirements: - Sub-100ms latency for players globally. - Real-time analytics on player behavior. - Seasonal traffic spikes (5x during holidays). - CI/CD pipeline for daily deployments. Constraints: - Migration must complete in 12 months. - Cannot exceed 4-hour downtime during cutover. - Dev team: 20 engineers (Java, MySQL). - Ops team: 5 engineers (limited cloud experience). QUESTION: To meet the requirement for real-time analytics on player behavior, which architecture should you recommend?

CASE STUDY: ShopGlobal Company Overview: ShopGlobal is an international e-commerce retailer. They are preparing for their largest annual sales event (Black Friday) and want to migrate off their aging on-premises infrastructure. Current Technical Environment: - 3 on-premises data centers (US-East, US-West, EU-Central). - VMware vSphere environment with 500 VMs. - Monolithic Java application running on Tomcat. - Oracle RAC database for transactions. - 50 TB of product images on SAN storage. Business Requirements: - Ensure 100% availability during the upcoming holiday season. - Modernize the application architecture over the next 3 years. - Reduce capital expenditure (CapEx) by shifting to an OpEx model. Executive Statements: - CEO: "Downtime during Black Friday costs us $1M per hour. We need bulletproof reliability." - CFO: "We want to stop buying hardware. Move everything to a pay-as-you-go model." - CTO: "We want to eventually move to microservices, but we don't have time to rewrite the app before the holidays." Technical Requirements: - Migrate the existing VMs to the cloud with minimal changes initially. - Implement a global CDN for product images to reduce latency. - Set up disaster recovery with an RPO of 15 minutes and RTO of 1 hour. - Ensure PCI-DSS compliance for payment processing. Constraints: - The migration must be completed in 4 months (before the code freeze). - The Oracle database license cannot be easily transferred to the cloud. - The team has no experience with Kubernetes or containers yet. QUESTION: Which database migration strategy addresses the Oracle licensing constraint while meeting the performance requirements for the monolithic application?

CASE STUDY: AutoMakers Inc Company Overview: AutoMakers Inc is a leading vehicle manufacturer transitioning to connected and autonomous vehicles. They need a platform to ingest, process, and analyze telemetry data from millions of cars. Current Technical Environment: - Legacy MQTT brokers on-premises. - Hadoop cluster for batch processing (nightly runs). - 100,000 connected cars sending 1 KB of data every minute. - On-premises data warehouse reaching capacity. Business Requirements: - Support 5 million connected cars within 3 years. - Enable real-time alerting for critical vehicle faults. - Provide predictive maintenance insights to customers. - Monetize anonymized traffic data. Executive Statements: - CEO: "Data is our new engine. We need real-time insights to improve safety." - CFO: "The platform must scale cost-effectively. We only want to pay for what we use." - CTO: "We need a fully managed serverless data pipeline to minimize operational overhead." Technical Requirements: - Ingest up to 1 million messages per second with low latency. - Process data in real-time for anomaly detection. - Store raw telemetry data indefinitely for machine learning model training. - Provide a scalable data warehouse for business intelligence analysts. Constraints: - Strict data privacy regulations (GDPR) require masking of PII. - Limited data engineering staff; prefer managed services. - Must integrate with existing on-premises identity provider (Active Directory). QUESTION: Which architecture should you recommend for the real-time ingestion and processing pipeline to meet the CTO's requirement for a fully managed serverless solution?

You are deploying a global API service that uses gRPC for communication. Clients are located worldwide. You need a load balancing solution that provides a single Anycast IP address, terminates TLS, and routes traffic to the closest healthy backend region. Which load balancer should you choose?

An enterprise is adopting a multi-cloud strategy. They have Kubernetes clusters running in Google Cloud (GKE), on-premises (VMware), and in AWS (EKS). The security team requires consistent RBAC policies, network security policies, and configuration management across all clusters, regardless of where they are hosted. Which TWO Google Cloud technologies should you recommend? (Select TWO)