Skip to content
RED SAGSkills

Medium Data Engineer questions

34 questions · 10 points each for a correct first answer.

easymediumhard
  1. 1.Tracking customer address historymedium
  2. 2.Incremental load with updated_atmedium
  3. 3.What causes a shufflemedium
  4. 4.Joining with a small lookup tablemedium
  5. 5.Ordering in Kafkamedium
  6. 6.Upserting into a target tablemedium
  7. 7.Why use ref() in dbtmedium
  8. 8.Handling late eventsmedium
  9. 9.Keeping the latest row per keymedium
  10. 10.RANK and DENSE_RANK with tiesmedium
  11. 11.NOT IN with a NULL in the listmedium
  12. 12.Day-over-day change with LAGmedium
  13. 13.WHERE filter after a LEFT JOINmedium
  14. 14.Counting orders for every customermedium
  15. 15.Table state after a MERGEmedium
  16. 16.Revenue doubled after a joinmedium
  17. 17.Employees above their team averagemedium
  18. 18.Keeping just the previous valuemedium
  19. 19.Data Vault building blocksmedium
  20. 20.Log-based CDC advantagesmedium
  21. 21.Duplicates from at-least-once deliverymedium
  22. 22.Surprise runs from catchupmedium
  23. 23.When a daily Airflow run startsmedium
  24. 24.When to cache in Sparkmedium
  25. 25.repartition vs coalescemedium
  26. 26.Eight consumers, six partitionsmedium
  27. 27.How Parquet skips datamedium
  28. 28.Undoing a bad loadmedium
  29. 29.LIMIT and BigQuery costmedium
  30. 30.Idle Snowflake warehouse costmedium
  31. 31.Filtering new rows in dbtmedium
  32. 32.Detecting stale source datamedium
  33. 33.What a data contract doesmedium
  34. 34.Rerunning a half-failed loadmedium