Matching a managed storage service to the workload it needs to serve

Google Cloud offers purpose-built managed storage services spanning relational OLTP, analytical OLAP, NoSQL, object, and in-memory workloads, and the exam expects you to map workload characteristics (data model, scale, consistency, latency, query pattern) to the right service. Choosing correctly hinges on distinguishing transactional vs analytical needs, structured vs unstructured data, and global vs regional consistency requirements.

Must-know

  • Use Cloud SQL for traditional relational OLTP (MySQL, PostgreSQL, SQL Server) at regional scale with vertical scaling limits; use AlloyDB for PostgreSQL-compatible workloads needing higher performance, HTAP analytics, and better scalability than Cloud SQL.
  • Use Spanner when you need horizontally scalable, globally distributed relational data with strong consistency and 99.999% availability SLA (multi-region), typically for mission-critical OLTP at massive scale.
  • Use BigQuery for serverless SQL analytics/data warehousing on structured/semi-structured data at petabyte scale; use BigLake to apply BigQuery's governance, security, and query engine over data stored in open formats (e.g., Parquet) in Cloud Storage or other lakes without duplicating data.
  • Use Bigtable for high-throughput, low-latency NoSQL wide-column workloads (time-series, IoT, ad tech) requiring massive write/read scale but with eventual consistency and no complex joins/transactions.
  • Use Firestore for flexible-schema NoSQL document data with real-time sync, mobile/web SDKs, and strong consistency for smaller-scale transactional app data (not for heavy analytics or massive throughput like Bigtable).
  • Use Cloud Storage for unstructured object data (files, backups, staging for pipelines) at any scale with storage classes for cost/latency tradeoffs, and Memorystore (Redis/Memcached) for managed in-memory caching to reduce latency for frequently accessed data, not as a system of record.
Drill this objectiveTake a weighted mockTry free practice questions

Coverage checked against the published exam guide on Aug 11, 2026.

These are independent practice questions, written against this certification's published exam guide. They are not the certification vendor's own questions, and not the real exam.