Soru

Zorluk: ZorDesigning Infrastructure for Business Requirements and Cost Optimization

A biomedical research facility processes and stores genomic data in a single Google Cloud region (uscentral1us-central1). The organization generates 500 TB500\text{ TB} of raw genomic sequencing files (FASTQ format) annually alongside structured variant analysis records. The raw sequencing files are accessed heavily during the first 30 days of initial pipeline analysis, queried infrequently between 30 and 365 days, and must be retained for 7 years to satisfy regulatory compliance. The structured variant analysis dataset requires traditional ACID-compliant relational transactions, operates entirely within the single region, and experiences a peak load of 1,500 queries per second. You need to design an infrastructure architecture that minimizes ongoing operational and storage costs while meeting all performance, transactional consistency, and compliance mandates. Which TWO architectural decisions should you recommend?

  1. Configure Cloud Storage Object Lifecycle Management rules on the raw sequencing data bucket to transition objects to Coldline Storage after 30 days and to Archive Storage after 365 days.Cevap
  2. Provision Cloud SQL for PostgreSQL configured with High Availability (regional failover) to manage the structured variant analysis data.Cevap
  3. C
    Deploy a multi-region Cloud Spanner instance to store structured variant analysis records to guarantee zero-downtime maintenance windows and horizontal scaling.
  4. D
    Order a Google Cloud Transfer Appliance to perform ongoing daily batch ingestion of raw sequencing files from regional sequencing hardware into Cloud Storage.

Cevap

The optimal architecture combines Cloud Storage Object Lifecycle Management (transitioning raw files to Coldline after 30 days and Archive after 365 days) with Cloud SQL for PostgreSQL configured for High Availability to handle single-region relational structured data efficiently.
Transitioning raw data from Standard to Coldline after 30 days and to Archive after 365 days aligns storage costs directly with access frequency while satisfying the 7-year compliance policy. For the structured database, Cloud SQL for PostgreSQL with High Availability satisfies single-region ACID requirements and 1,500 QPS at a fraction of the cost of Cloud Spanner.

Adım Adım Çözüm

1
Analyze raw file storage lifecycle access patterns and retention rules
Identified high access for 30\le 30 days (Standard Storage), infrequent access between 30 and 365 days (Coldline Storage), and strict 7-year retention with rare access (Archive Storage).
Automating storage class transitions using Lifecycle Management minimizes total cost of storage while retaining required access and compliance.
2
Evaluate compute and database scalability/consistency requirements for structured data
Workload is regional, requires ACID compliance, and handles 1,500 QPS.
Cloud SQL handles thousands of QPS within a single region cost-effectively, making Cloud Spanner over-engineered and cost-prohibitive for non-global requirements.

Anahtar Kavram

Cost optimization through storage lifecycle tiering and database right-sizing based on spatial scale and access patterns.
Bu soruyu puanla