Examkin

Question

Difficulty: EasySelecting 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 PostgreSQLAnswer
  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

Answer

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.

Step-by-Step Solution

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.

Key Concept

Selecting Cloud SQL over Cloud Spanner for single-region relational workloads
Estimated Time:45s
Rate this question

Topics

Selecting and Designing Storage and Database Resources