PDE - Storing Data - Section 3.2
Plan data warehouse schemas in BigQuery, including data model design, normalisation decisions, and architecture that supports required data access patterns.
Design BigQuery warehouse schemas by choosing between normalised and denormalised models, and apply partitioning and clustering strategies to optimise query performance and reduce slot consumption for the expected access patterns.
BigQuerySchema designPartitioningClustering
More in this domain
Back to all Storing Data objectives, or the PDE cert hub.
Examworthy is not affiliated with or endorsed by Google Cloud. Original, blueprint-aligned practice material only.