Study guide
GCP Data Engineer study guide
Read a lesson, then practice the ideas you want to remember.
Lessons
- Advanced SQL in BigQuery: Window Analytic Fu
- Modern SQL Orchestration with Dataform: DAG
- BI Engine In-Memory Acceleration and Enterpr
- Pipeline Robustness: Dead-Letter Queues, Err
- Side Inputs, Broadcast Joins, and Stateful S
- Watermarks, Triggers, Accumulating vs Discar
- BigLake Architecture: Unified Multicloud Sto
- BigQuery Omni: Multicloud Analytics Across A
- Analytics Hub and Federated Computational Go
- Batch vs Streaming Processing Trade-Offs and
- Change Data Capture with Datastream for Cont
- Data Pipeline Planning: Sources, Sinks, and
- BigQuery Architecture: Capacitor Columnar Fo
- BigQuery Clustering: Cardinality, Multi-Colu
- BigQuery Partitioning: Ingestion-Time, Date/
- Data Warehouse Modeling: Normalization, Star
- Cloud Data Fusion: Visual ETL/ELT Pipelines,
- Cloud Dataproc: Architecture, Ephemeral vs P
- Dataproc Serverless and Autoscaling Policies
- BigQuery ML Architecture: In-Database Traini
- Feature Engineering: ML.TRANSFORM, Preproces
- MLOps, Model Governance, Continuous Monitori
- Workflow Orchestration with Cloud Composer:
- Unified Data Governance with Dataplex: Lakes
- Pipeline Observability, FinOps, and Cost Opt
- Apache Beam Programming Model: Pipelines, PC
- Cloud Dataflow Architecture: Autoscaling, Wo
- Windowing Strategies in Streaming Dataflow:
- Data Residency, Sovereignty, and Regulatory
- High Availability, Regional vs Multi-Regiona
- Modern Data Architecture Patterns: Data Mesh
- Cloud Bigtable Architecture: Storage Model,
- Cloud Bigtable Row Key Design: Lexicographic
- Cloud Firestore: Document Model, Real-Time S
- Data Encryption, Key Management, and Cloud K
- Cloud IAM, Service Accounts, and Resource Hi
- Sensitive Data Protection: Cloud DLP, De-ide
- Cloud SQL: High Availability, Read Replicas,
- Cloud Spanner Architecture: TrueTime, Extern
- Cloud Spanner Schema Design: Primary Keys, I
- Cloud Storage Architecture: Storage Classes,
- Cloud Storage Security: Bucket Lock, Access
- GCP Storage Selection Decision Matrix: Relat
- Cloud Pub/Sub Core Architecture: Topics, Sub
- Pub/Sub BigQuery/Cloud Storage Direct Subscr
- Pub/Sub Message Ordering, Exactly-Once Deliv