Study guide

GCP Data Engineer study guide

Read a lesson, then practice the ideas you want to remember.

Lessons

  1. Advanced SQL in BigQuery: Window Analytic Fu
  2. Modern SQL Orchestration with Dataform: DAG
  3. BI Engine In-Memory Acceleration and Enterpr
  4. Pipeline Robustness: Dead-Letter Queues, Err
  5. Side Inputs, Broadcast Joins, and Stateful S
  6. Watermarks, Triggers, Accumulating vs Discar
  7. BigLake Architecture: Unified Multicloud Sto
  8. BigQuery Omni: Multicloud Analytics Across A
  9. Analytics Hub and Federated Computational Go
  10. Batch vs Streaming Processing Trade-Offs and
  11. Change Data Capture with Datastream for Cont
  12. Data Pipeline Planning: Sources, Sinks, and
  13. BigQuery Architecture: Capacitor Columnar Fo
  14. BigQuery Clustering: Cardinality, Multi-Colu
  15. BigQuery Partitioning: Ingestion-Time, Date/
  16. Data Warehouse Modeling: Normalization, Star
  17. Cloud Data Fusion: Visual ETL/ELT Pipelines,
  18. Cloud Dataproc: Architecture, Ephemeral vs P
  19. Dataproc Serverless and Autoscaling Policies
  20. BigQuery ML Architecture: In-Database Traini
  21. Feature Engineering: ML.TRANSFORM, Preproces
  22. MLOps, Model Governance, Continuous Monitori
  23. Workflow Orchestration with Cloud Composer:
  24. Unified Data Governance with Dataplex: Lakes
  25. Pipeline Observability, FinOps, and Cost Opt
  26. Apache Beam Programming Model: Pipelines, PC
  27. Cloud Dataflow Architecture: Autoscaling, Wo
  28. Windowing Strategies in Streaming Dataflow:
  29. Data Residency, Sovereignty, and Regulatory
  30. High Availability, Regional vs Multi-Regiona
  31. Modern Data Architecture Patterns: Data Mesh
  32. Cloud Bigtable Architecture: Storage Model,
  33. Cloud Bigtable Row Key Design: Lexicographic
  34. Cloud Firestore: Document Model, Real-Time S
  35. Data Encryption, Key Management, and Cloud K
  36. Cloud IAM, Service Accounts, and Resource Hi
  37. Sensitive Data Protection: Cloud DLP, De-ide
  38. Cloud SQL: High Availability, Read Replicas,
  39. Cloud Spanner Architecture: TrueTime, Extern
  40. Cloud Spanner Schema Design: Primary Keys, I
  41. Cloud Storage Architecture: Storage Classes,
  42. Cloud Storage Security: Bucket Lock, Access
  43. GCP Storage Selection Decision Matrix: Relat
  44. Cloud Pub/Sub Core Architecture: Topics, Sub
  45. Pub/Sub BigQuery/Cloud Storage Direct Subscr
  46. Pub/Sub Message Ordering, Exactly-Once Deliv