Soru

Zorluk: KolaySelecting and Designing Storage and Database Resources

An organization plans to migrate a single-region, on-premises relational PostgreSQL database to Google Cloud. The application requires standard ACID transactional compliance and predictable performance within a single GCP region, with no requirement for global scale or multi-region availability. Which Google Cloud managed database service should the architect choose to minimize operational complexity and cost?

  1. Cloud SQL for PostgreSQLCevap
  2. B
    Cloud Spanner
  3. C
    Cloud Storage configured with Customer-Supplied Encryption Keys (CSEK)
  4. D
    Cloud Bigtable with Identity and Access Management (IAM) policy bindings

Cevap

Cloud SQL for PostgreSQL is the optimal choice for a single-region relational database workload requiring standard ACID compliance.
Cloud SQL for PostgreSQL is a fully managed relational database service designed for workloads operating within a single region. It provides full PostgreSQL compatibility, standard ACID compliance, and easy maintenance at a significantly lower cost compared to multi-region scaling solutions.

Adım Adım Çözüm

1
Analyze workload storage requirements
The application requires a relational database (PostgreSQL) with ACID compliance operating strictly within a single GCP region.
Determining relational model requirements and regional scope eliminates non-relational and multi-region database services.
2
Compare candidate GCP database services
Cloud SQL supports managed single-region PostgreSQL, whereas Cloud Spanner is optimized for multi-region global scale.
Choosing Cloud SQL aligns database capabilities with workload scale while preventing over-provisioning and excess costs.
3
Finalize database selection
Select Cloud SQL for PostgreSQL.
Cloud SQL satisfies all technical requirements with minimal management effort and optimal cost efficiency.

Anahtar Kavram

Selecting Cloud SQL over Cloud Spanner for single-region relational workloads
Tahmini Süre:45s
Bu soruyu puanla