Start here in Interview Questions
The most useful guides in this topic, not just the most recent.
Interview Questions Guides & Tutorials
Curated interview question banks with answers — SQL, Python, data science, Spark, Power BI, AWS, ADF and more.
Interview Questions articles
Redshift Interview Questions and Answers
Redshift interviews keep returning to two design choices: how rows are distributed across slices, and how they are sorted. Both are modelled here on three million real taxi trips, showing a distribution key that leaves five of eight slices idle, a join that moves 87.5% of rows, and a sort key that skips most blocks.
Mock Interview Guide: Practising Out Loud the Right Way
Reading answers is not the same as saying them under time pressure. This guide shows how to run mock interviews that improve performance: a realistic session format, a written scoring rubric, thinking aloud in technical rounds, recording and reviewing, and turning each session's weakest moment into the next practice.