Shaping a data model for how it will actually be queried

Designing the data model for Google Cloud storage services means matching schema design and access patterns to the target system's strengths, whether that's normalized relational schemas for Cloud SQL/Spanner, denormalized wide tables for BigQuery, or key-based flat schemas for Bigtable/Firestore. On the exam, you must recognize which service fits a given access pattern, consistency need, and scale, then design the schema (columns, keys, partitioning) accordingly.

Must-know

• In BigQuery, denormalize and use nested/repeated (STRUCT/ARRAY) fields to avoid JOINs, and design partitioning (by date/time) and clustering (by frequently filtered/grouped columns) to reduce bytes scanned and cost.
• In Bigtable, schema design centers on a single row key that supports the required query patterns since it's the only indexed field; avoid monotonically increasing keys (e.g., timestamps) as row key prefixes to prevent hotspotting, and use field promotion/reversal or salting instead.
• In Cloud Spanner, choose primary keys carefully to avoid hotspotting on sequential IDs (use UUIDs or bit-reversed sequential IDs), and use interleaved tables to co-locate parent-child data for efficient joins and locality.
• Firestore/Datastore data modeling is document/entity-based with hierarchical collections and subcollections; design for query patterns since queries require indexes and denormalization is common to avoid multiple round trips.
• Choose Cloud SQL for normalized relational schemas needing ACID transactions and joins at moderate scale, and Spanner when you need the same relational/ACID guarantees but at global horizontal scale.
• Always let query patterns and access frequency drive the model: OLTP workloads favor normalization and low-latency point lookups, while OLAP/analytics workloads (BigQuery) favor denormalization for scan efficiency.

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.