Examkin

Question

Difficulty: MediumSelecting and Designing Storage and Database Resources

An enterprise audit software provider is designing the storage tier for a new compliance tracking application. The application operates entirely within a single GCP region and requires a fully managed relational database with strict ACID transaction guarantees, standard SQL query support, and automatic regional failover for high availability. The workload is projected at 1,200 write transactions per second during peak hours. Which database resource selection best satisfies these requirements while minimizing cost and architectural complexity?

  1. Cloud SQL for PostgreSQL deployed with regional High Availability (HA) enabledAnswer
  2. B
    Cloud Spanner deployed with a single-region instance configuration
  3. C
    Cloud SQL for PostgreSQL configured with Customer-Supplied Encryption Keys (CSEK)
  4. D
    Cloud Storage bucket using Storage Transfer Service for real-time transaction ingestion

Answer

Cloud SQL for PostgreSQL deployed with regional High Availability (HA) enabled
Cloud SQL for PostgreSQL with regional High Availability (HA) provides a fully managed ACID-compliant relational database with automatic cross-zone failover within a single region. It easily handles moderate throughput requirements while optimizing costs and architectural simplicity.

Step-by-Step Solution

1
Analyze technical and operational constraints
The target workload requires a single-region relational database with full ACID compliance, standard SQL interface, high availability across zones, and modest throughput (1,200 TPS).
Identifying the scope (single region) and data model (relational SQL) narrows down GCP database options.
2
Compare database services for single-region relational workloads
Cloud SQL is optimized for single-region relational databases. Cloud Spanner is engineered for multi-region global distribution and massive horizontal scaling, making it cost-prohibitive for standard single-region needs.
Matching workload scale to resource capabilities ensures cost-effective architecture.
3
Verify high availability configuration
Enabling regional HA on Cloud SQL provisions a primary and standby database instance across distinct zones with automatic synchronous replication and failover.
This directly fulfills the high availability requirement without requiring complex multi-master replication.

Key Concept

Selecting Cloud SQL vs. Cloud Spanner based on regional scope, throughput requirements, and cost efficiency
Rate this question

Topics

Selecting and Designing Storage and Database Resources