Interview questionsStart free
Sharding, replication & partitioningMediumSDE-2
Your bookings are sharded by user_id. Now the operations team needs 'all bookings for hotel X in the last 7 days', and the query is slow because it hits all 64 shards. What do you do?
Asked at
AirbnbMakeMyTrip
Think first
Answer out loud as you would in the room — clarify, give numbers, name the trade-off — then compare with the model answer.
Go deeper
Saved on this device. Create a free account to keep it on every device.
Practise this with Sam
A real mock interview, out loud, with an honest scorecard. Free to start.