Question

Difficulty: HardDesigning Infrastructure for Business Requirements and Cost Optimization

A smart energy grid company ingests continuous HTTP telemetry streams from millions of regional meters and executes scheduled nightly batch processing for billing calculations. Raw telemetry payloads must be retained for 55 years for regulatory compliance but are accessed less than once per year after 3030 days. The company's database stores regional device state metadata requiring standard relational SQL querying and high availability, but does not require global multi-region write synchronization. The chief architecture officer has set strict business mandates to minimize baseline compute management overhead, eliminate unnecessary database licensing costs, and reduce long-term cold storage expenditure. Which TWO architectural decisions should you recommend? (Select TWO.)

  1. Deploy the stateless HTTP telemetry ingestion microservices on Cloud Run, and set Cloud Storage Lifecycle Management rules to transition raw telemetry objects to Coldline Storage after 30 days and Archive Storage after 365 days.Answer
  2. Provision regional Cloud SQL for PostgreSQL with High Availability for device metadata, and execute nightly batch processing jobs using Spot VMs or Cloud Run Jobs.Answer
  3. C
    Deploy the stateless HTTP ingestion services on a Dedicated GKE Autopilot cluster across three regions to guarantee container resource reservation for all ingress traffic.
  4. D
    Provision a multi-region Cloud Spanner instance to store device metadata, ensuring continuous cross-continent synchronous write scalability.
  5. E
    Purchase 3-year Committed Use Discounts (CUDs) covering peak compute capacity for all nightly batch processing virtual machines on standard Compute Engine VMs.

Answer

The optimal solution requires deploying stateless HTTP ingestion microservices on Cloud Run paired with Cloud Storage Lifecycle Management rules for cold data archiving, along with utilizing regional Cloud SQL for PostgreSQL with High Availability and executing fault-tolerant nightly batch jobs on Spot VMs or Cloud Run Jobs.
Combining Cloud Run with Cloud Storage Lifecycle Management provides automated scaling down to zero for HTTP services while drastically reducing storage expenses for long-term audit logs. Selecting regional Cloud SQL with HA satisfies relational database needs without Spanner's expensive multi-region overhead, and running batch jobs on Spot VMs capitalizes on discounted, transient compute capacity.

Step-by-Step Solution

1
Analyze stateless microservice compute and long-term storage requirements.
Cloud Run handles HTTP traffic serverlessly with zero idle cost, and Cloud Storage Lifecycle Management automates cost reduction for compliance data by moving objects to Coldline and Archive tiers.
Reduces operational management overhead and storage costs without architectural over-engineering.
2
Evaluate relational database scale and workload batch characteristics.
Regional Cloud SQL for PostgreSQL HA satisfies transactional single-region metadata needs without multi-region Spanner costs. Nightly batch workloads leverage Spot VMs or Cloud Run Jobs to minimize compute expenditure.
Avoids over-provisioning global database infrastructure and eliminates idle compute capacity billing for intermittent batch processing.

Key Concept

Balancing Serverless Compute, Database Right-Sizing, and Automated Lifecycle Storage Optimization in GCP Architecture
Estimated Time:2m 30s
Rate this question