Question

Difficulty: EasySelecting and Designing Storage and Database Resources

A regional retail firm is selecting a managed database service to handle operational sales orders within a single Google Cloud region. The application requires full ACID transaction compliance and standard relational SQL capabilities, but does not require cross-region replication or global horizontal scale. Which Google Cloud service should be selected?

Cloud SQLAnswer
B
Cloud Spanner
C
Transfer Appliance
D
Cloud Storage using Customer-Supplied Encryption Keys (CSEK)

Answer

Cloud SQL is the optimal choice for single-region relational workloads requiring ACID transactions and standard SQL functionality.

Cloud SQL is a fully managed relational database service supporting PostgreSQL, MySQL, and SQL Server. It delivers full ACID compliance, standard SQL query support, and high availability within a single region, matching the workload requirements while avoiding unnecessary costs.

Step-by-Step Solution

1

Analyze the workload requirements

Identified operational sales order processing requiring relational SQL queries and strict ACID transaction compliance in a single region.

Understanding data structure and access patterns dictates whether relational or NoSQL solutions are required.

2

Evaluate scalability and regional scope

The application operates strictly within a single Google Cloud region and does not require global multi-region synchronous replication.

Single-region relational requirements are best matched with regional database services to optimize licensing and operational costs.

3

Select the optimal GCP database resource

Selected Cloud SQL as it provides fully managed relational database engines with ACID compliance at an appropriate cost profile.

Cloud SQL satisfies all technical requirements without the unnecessary cost overhead of globally distributed engines.

Key Concept

Relational Database Selection for Single-Region Workloads

Rate this question

Topics

Selecting and Designing Storage and Database Resources