Examkin

Question

Difficulty: EasySelecting and Designing Storage and Database Resources

An organization is deploying a standard internal business application in a single Google Cloud region. The application requires a fully managed relational database that supports standard SQL queries and ACID transactions. The application workload does not require horizontal scaling across multiple regions or global availability. Which Google Cloud service should you select to meet these requirements with minimal cost and operational overhead?

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

Answer

Cloud SQL is the optimal service for single-region managed relational database workloads requiring standard SQL capabilities and ACID compliance.
Cloud SQL is Google Cloud's managed relational database service specifically built for regional MySQL, PostgreSQL, and SQL Server workloads requiring ACID transactions and full SQL capabilities.

Step-by-Step Solution

1
Analyze workload requirements
Identified the need for a relational database with SQL support, ACID compliance, and single-region operational scope.
Matching access patterns and functional constraints determines the appropriate GCP storage category.
2
Evaluate database service options against operational complexity and cost
Cloud SQL satisfies all relational and transactional requirements within a single region at a lower cost tier compared to globally distributed alternatives.
Cloud Spanner is intended for multi-region or horizontally scaled global relational workloads, making Cloud SQL the best fit for standard single-region applications.

Key Concept

Selecting Cloud SQL versus Cloud Spanner based on regional scale and relational database requirements.
Rate this question

Topics

Selecting and Designing Storage and Database Resources