Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Data Engineer
/
Questions
/
Indexing and query tuning
Data Engineer
Indexing and query tuning questions
15 questions on Indexing and query tuning for data engineers, easiest first.
Easy
3
Partitioning an events table
easy
Folders named dt=2026-10-01
easy
Reducing a topic's partitions
easy
Medium
8
repartition vs coalesce
medium
Stopping full scans of a big table
medium
Where a keyed record lands
medium
Records sent with no key
medium
Partitions for a throughput target
medium
An extra topic appears
medium
One partition far busier than others
medium
Key for order lifecycle events
medium
Hard
4
Iceberg hidden partitioning
hard
Which day does an event belong to
hard
A MERGE that scans 5 years of data
hard
Cost of salting a hot key
hard
