Soru

Zorluk: KolaySelecting and Designing Storage and Database Resources

A company is designing a web application hosted in a single Google Cloud region. The solution requires storing structured relational operational data with full ACID transaction support, as well as storing large volume unstructured user-uploaded media files served over HTTP. Which TWO Google Cloud storage solutions should the architect select to meet these requirements cost-effectively? (Select TWO)

  1. A
    Cloud Spanner for storing the single-region structured relational database workload
  2. Cloud SQL for storing the single-region structured relational database workloadCevap
  3. Cloud Storage for storing and serving the unstructured user-uploaded media filesCevap
  4. D
    Transfer Appliance for serving live unstructured user-uploaded media files over HTTP

Cevap

The correct architecture combines Cloud SQL for the single-region relational database workload and Cloud Storage for storing unstructured media files.
Cloud SQL provides a fully managed single-region relational database with full ACID compliance for structured operational data, while Cloud Storage provides highly scalable object storage suited for serving unstructured media files directly via HTTP.

Adım Adım Çözüm

1
Analyze relational database requirements
The requirement calls for a single-region, ACID-compliant relational database. Cloud SQL is the ideal fit as it delivers fully managed relational database features without the cost overhead of globally distributed solutions.
Single-region relational workloads do not require multi-region horizontal scaling.
2
Analyze unstructured file storage requirements
User-uploaded media files require scalable object storage accessible over HTTP, which is the core capability of Cloud Storage.
Cloud Storage provides durable object storage with direct HTTP access capabilities.

Anahtar Kavram

Selecting GCP database and storage services based on data structure, regional scope, and access patterns.
Bu soruyu puanla