Skip to content
RED SAGSkills

Hard Data Engineer questions

32 questions · 20 points each for a correct first answer.

easymediumhard
  1. 1.One task takes foreverhard
  2. 2.Exactly-once end to endhard
  3. 3.Millions of tiny fileshard
  4. 4.Safe backfillshard
  5. 5.Applying CDC eventshard
  6. 6.Cutting warehouse scan costhard
  7. 7.Upstream renamed a columnhard
  8. 8.Why table formats existhard
  9. 9.Running total with tied dateshard
  10. 10.LAST_VALUE returns the current rowhard
  11. 11.Longest login streakhard
  12. 12.FULL OUTER JOIN row counthard
  13. 13.GROUP BY with NULL keyshard
  14. 14.Recursive CTE stopping pointhard
  15. 15.Double counting in an SCD2 joinhard
  16. 16.Which late event is kepthard
  17. 17.Committing offsets too earlyhard
  18. 18.Adding partitions to a keyed topichard
  19. 19.A slow Python UDF in PySparkhard
  20. 20.Distinct users on billions of rowshard
  21. 21.Iceberg hidden partitioninghard
  22. 22.VACUUM and time travelhard
  23. 23.Two writers, one lakehouse tablehard
  24. 24.Copy-on-write vs merge-on-readhard
  25. 25.Clustering for two filter columnshard
  26. 26.Choosing a Redshift DISTKEYhard
  27. 27.Rows missed by a strict watermarkhard
  28. 28.New column in a dbt incremental modelhard
  29. 29.Hashing emails is not anonymisinghard
  30. 30.Overwrite deleted the whole tablehard
  31. 31.Which day does an event belong tohard
  32. 32.Sensors blocking every workerhard