Soru

Zorluk: OrtaSelecting and Designing Storage and Database Resources

An enterprise retail company is designing the data architecture for a new e-commerce platform on Google Cloud. The application architecture requires two separate storage components:
1. A transactional relational database for order processing that must support SQL queries, scale across multiple geographic regions, and guarantee strong ACID consistency.
2. A high-throughput, low-latency key-value store to maintain real-time user shopping cart sessions.

Which TWO Google Cloud database services should the Cloud Architect select to meet these requirements?

  1. Cloud Spanner for global multi-region transactional order processing with strong ACID compliance.Cevap
  2. Cloud Bigtable for high-throughput, low-latency key-value shopping cart session storage.Cevap
  3. C
    Cloud SQL for PostgreSQL configured with regional high availability for global multi-region order processing.
  4. D
    Storage Transfer Service to stream real-time key-value shopping cart session updates directly to Cloud Storage.

Cevap

Cloud Spanner for global multi-region transactional order processing, and Cloud Bigtable for high-throughput, low-latency session key-value storage.
Cloud Spanner is specifically designed for globally distributed relational workloads requiring strong ACID consistency and multi-region write scalability. Cloud Bigtable delivers high-throughput, low-latency key-value performance required for user session tracking.

Adım Adım Çözüm

1
Analyze the requirements for the order processing database
The database requires relational SQL support, multi-region horizontal scaling, and strong ACID consistency.
Cloud Spanner is the only native GCP database offering globally distributed relational scale with strong consistency.
2
Analyze the requirements for the shopping cart session database
The database requires high throughput, sub-10ms response latency, and a key-value data structure.
Cloud Bigtable excels at scalable key-value access with single-digit millisecond latency.
3
Evaluate and reject improper storage options
Cloud SQL cannot support multi-region scale with global consistency, and Storage Transfer Service is an offline/batch transfer tool.
Matching workload access patterns and scalability boundaries ensures valid architectural selection.

Anahtar Kavram

Database Selection based on Scale, Latency, and Consistency Requirements
Bu soruyu puanla