Examkin

Question

Difficulty: EasySelecting and Designing Storage and Database Resources

A financial analytics startup is building an internal back-office reporting application. The application requires a fully managed relational database supporting standard SQL and ACID transactions within a single Google Cloud region, with no requirement for global multi-region consistency or multi-region horizontal scaling. Which database service should the architect select?

  1. Cloud SQLAnswer
  2. B
    Cloud Spanner
  3. C
    Transfer Appliance
  4. D
    Cloud Storage with Customer-Supplied Encryption Keys (CSEK)

Answer

Cloud SQL is the optimal choice because it provides a fully managed relational database engine (PostgreSQL, MySQL, SQL Server) with standard ACID compliance for single-region applications without the complexity and cost of global scaling services.
Cloud SQL is designed specifically for fully managed relational database workloads (such as PostgreSQL, MySQL, and SQL Server) operating within a single region. It fully supports standard ACID transactions and SQL syntax with minimal operational overhead.

Step-by-Step Solution

1
Analyze database workload requirements
The application requires structured relational database support, standard SQL queries, ACID transaction compliance, and operates entirely within a single Google Cloud region.
Identifying access patterns and regional bounds narrows down the suitable database category.
2
Evaluate GCP managed database options
Cloud SQL delivers standard relational engines suited for single-region scale, whereas Cloud Spanner is engineered for global multi-region horizontal scaling.
Choosing Cloud SQL satisfies all architectural constraints while avoiding unnecessary cost and complexity.

Key Concept

Selecting Cloud SQL for single-region relational database workloads instead of Cloud Spanner
Rate this question

Topics

Selecting and Designing Storage and Database Resources