Turning business requirements into a concrete storage design
Mapping business requirements to storage means matching data shape (structured, semi-structured, unstructured), access pattern (OLTP vs OLAP vs cache), scale, and consistency needs to the right managed service. The exam tests your ability to read a scenario and quickly rule out mismatched services based on throughput, latency, transactionality, and schema flexibility clues.
1 · Learn the must-know
- Cloud SQL suits traditional relational OLTP workloads that fit on a single instance (with read replicas) and need standard SQL with ACID transactions at moderate scale.
- Cloud Spanner is the choice when you need horizontal scalability, global distribution, strong consistency, and SQL with ACID transactions simultaneously, something Cloud SQL cannot do.
- Bigtable is built for high-throughput, low-latency NoSQL workloads (IoT, time-series, ad-tech) with petabyte-scale data, but only becomes cost-effective at large scale (generally recommended above ~1TB) and lacks multi-row transactions or joins.
- Firestore (Datastore mode/Native mode) targets semi-structured document data for web/mobile apps needing real-time sync, offline support, and flexible schemas rather than heavy analytical queries.
- BigQuery is the default for OLAP/analytical workloads on structured or semi-structured data at any scale, offering serverless SQL analytics but is not designed as a transactional, row-level update system despite supporting DML.
- Cloud Storage is the answer whenever requirements mention unstructured data, data lakes, backups, or staging before ETL/ELT, and it is priced/tiered (Standard, Nearline, Coldline, Archive) based on access frequency and retention needs.
2 · Check your understanding
A global retail company is redesigning its inventory management platform. The new system must support strong (external) consistency across regions, scale horizontally to handle petabytes of data, expose a SQL interface for existing reporting tools, and guarantee 99.999% availability even during a regional outage. Which storage service best satisfies all of these business requirements?
What you have tried across GCP PDE's objectives, not a readiness score.
Designing data processing systems~22% of the exam0 of 17 tried
Ingesting and processing the data~25% of the exam0 of 11 tried
Storing the data~20% of the exam0 of 13 tried
Preparing and using data for analysis~15% of the exam0 of 11 tried
Maintaining and automating data workloads~18% of the exam0 of 15 tried
3 · Keep going
Ready for more? Take a weighted mock or try free practice questions.