Data Engineer
Data warehousing and dbt questions
20 questions on Data warehousing and dbt for data engineers, easiest first.
Easy 3
Medium 7
Hard 10
- Millions of tiny fileshard
- Why table formats existhard
- Distinct users on billions of rowshard
- Iceberg hidden partitioninghard
- VACUUM and time travelhard
- Two writers, one lakehouse tablehard
- Copy-on-write vs merge-on-readhard
- Clustering for two filter columnshard
- Choosing a Redshift DISTKEYhard
- New column in a dbt incremental modelhard