Is One Side Small Enough

Concepts covered: paBroadcastJoin

The strongest opening move is a question, not an answer. Before you commit to broadcast, ask how big the small side actually is. Something like: is the lookup table small enough to fit in memory on every executor? That one question does 3 things at once. It shows you know broadcast depends on size, it gets you the number you need to justify the choice, and it keeps you from blurting a technique that might not apply. Either answer moves you forward If the interviewer says the lookup is a few megabytes, or a small reference table, you have your answer and you can commit to broadcast with confidence. If they say it is actually tens of gigabytes, you have just saved yourself from recommending something that would blow up, and you can pivot to a different strategy. Either way, asking the size f

About This Interactive Section

This section is part of the The Join Problem lesson on DataDriven, a free data engineering interview prep platform. Each section includes explanations, worked examples, and hands-on code challenges that execute in real time. SQL queries run against a live database. Python runs in a sandboxed Docker container. Data modeling problems validate against interactive schema canvases. All content is framed around what data engineering interviewers actually test at companies like Meta, Google, Amazon, Netflix, Stripe, and Databricks.

How DataDriven Lessons Work

DataDriven combines four interview rounds (SQL, Python, Data Modeling, Pipeline Architecture) with adaptive difficulty and spaced repetition. Easy problems get harder as you improve. Weak concepts resurface until you master them. Your readiness score tracks progress across every topic interviewers test. Every lesson section ends with problems you solve by writing and running real code, not by picking multiple-choice answers.