How would you implement pagination in a feed API with millions of records where new ones are constantly being added? What options do you know, and how do they differ?
~4 min by voice
How to approach it
The interviewer checks whether the candidate understands why naive LIMIT/OFFSET pagination breaks on large, constantly changing data, and whether they can properly design keyset (cursor) pagination with all the details: a unique key, an index, the cursor format, the limitations.
The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.