BigQuery

High-Throughput Web Apps—Compute vs Storage | GCP PCA

7 January 2026·616 words·3 mins

Architecture Drills Google Cloud Platform GCP PCA GCP FinOps SRE Cloud Run Bigtable BigQuery

A fintech startup must handle 500K requests per second with cost constraints. This drill explores managed compute vs. VM autoscaling and BigQuery vs. Bigtable for real-time exact-match storage.

Data Ingestion Pipeline Service Trade-offs | GCP ACE

6 January 2026·545 words·3 mins

Architecture Drills Google Cloud Platform GCP ACE GCP FinOps SRE Cloud Pub/Sub Dataflow Bigtable BigQuery

A global IoT gaming company must process large-scale time-series data from devices efficiently, balancing simplicity, scalability, and analytics speed.

GDPR BigQuery Deletion Decision Trade-offs | GCP PCA

9 December 2025·734 words·4 mins

Architecture Drills Google Cloud Platform GCP PCA GCP FinOps SRE BigQuery

A global sports analytics company must design a solution to efficiently process and delete sensitive user data from BigQuery upon request, balancing compliance, cost, and operational complexity.