Data Engineering Study Guide 2026
Everything you need to pass the Data Engineering exam in one place: the exam format, every topic to study, real practice questions with explanations, flashcards, and full-length practice tests. Free, no sign-up needed.
📋 Data Engineering Exam Format at a Glance
📚 Data Engineering Topics to Study (69)
✍️ Sample Data Engineering Questions & Answers
1. Which US law protects the privacy of patient health information?
HIPAA governs protected health information in the US.
2. The 'timestamp' snapshot strategy in dbt relies on:
The timestamp strategy trusts an updated_at field to detect modified records.
3. A query spilling to disk during a sort or aggregation usually indicates:
When working memory is exceeded, the engine spills intermediate data to disk, slowing the query.
4. Which architecture uses both a batch layer and a speed layer to serve queries?
Lambda architecture combines a batch layer for accuracy with a speed layer for low latency.
5. Which key type uniquely identifies a row in a dimension table within the warehouse, independent of the source system?
A surrogate key is a warehouse-generated integer that uniquely identifies dimension rows regardless of source identifiers.
6. An accumulating snapshot fact table is most appropriate for modeling:
Accumulating snapshots track a process with multiple milestone dates, updating the same row as stages complete.