Examkin

Question

Difficulty: Very hardSelecting and Designing Storage and Database Resources

A global fintech company is migrating its core multi-region banking ledger application to Google Cloud. The workload requires full transactional ACID compliance, relational database semantics across multiple regions, horizontal scale for high-throughput reads and writes, and a high availability SLA of 99.999%. Which database resource should you select to meet these business and technical requirements?

  1. A
    Cloud SQL for PostgreSQL configured with High Availability (HA) in the primary region and cross-region read replicas.
  2. Cloud Spanner provisioned as a multi-region instance configuration across the required geographic regions.Answer
  3. C
    Cloud Storage bucket architecture configured with continuous online streaming via Storage Transfer Service.
  4. D
    Cloud Bigtable clusters configured with multi-cluster routing and Customer-Supplied Encryption Keys (CSEK) managed manually.

Answer

Cloud Spanner provisioned as a multi-region instance configuration across the required geographic regions.
Provisioning Cloud Spanner as a multi-region instance is the correct choice because Cloud Spanner natively supports global relational tables with strong ACID consistency across multiple regions, horizontal scale for reads and writes, and provides an industry-leading 99.999% availability SLA.

Step-by-Step Solution

1
Analyze workload requirements
Identified requirements for relational schema enforcement, multi-region horizontal write scale, global ACID consistency, and a 99.999% SLA.
Determines the storage class and database engine required by comparing GCP database capability limits.
2
Evaluate database candidates against relational multi-region scale
Cloud SQL cannot support multi-region write scaling or 99.999% SLA. Cloud Bigtable lacks relational multi-table ACID guarantees.
Narrowing down service capabilities against stringent availability and transactional constraints.
3
Select optimal service
Cloud Spanner meets all criteria by providing external consistency, multi-region ACID transactions, high availability (99.999%), and relational SQL capabilities.
Cloud Spanner is specifically designed for enterprise-grade global relational workloads requiring high availability.

Key Concept

Selecting Cloud Spanner for globally distributed relational workloads requiring strong consistency and 99.999% SLA
Rate this question

Topics

Selecting and Designing Storage and Database Resources