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)
- ACloud Spanner for storing the single-region structured relational database workload
- Cloud SQL for storing the single-region structured relational database workloadAnswer
- Cloud Storage for storing and serving the unstructured user-uploaded media filesAnswer
- DTransfer Appliance for serving live unstructured user-uploaded media files over HTTP
Answer
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.
Step-by-Step Solution
Key Concept
Selecting GCP database and storage services based on data structure, regional scope, and access patterns.