Data warehousing and dbt
20 practice items · needed by 1 role
Easy 3Medium 7Hard 10
Practice questions
- What a dbt model iseasy
- Built-in dbt testseasy
- Data lake vs warehouseeasy
- Why use ref() in dbtmedium
- How Parquet skips datamedium
- Undoing a bad loadmedium
- LIMIT and BigQuery costmedium
- Idle Snowflake warehouse costmedium
- Filtering new rows in dbtmedium
- Detecting stale source datamedium
- 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