Start here. This is the direct spoken answer to practice first.
Why this question matters
Interviewers are listening for judgment, not heroics. The best stories show how the candidate protected the important parts while making a realistic delivery choice.
I had a deadline where we needed a usable admin search quickly. The ideal design involved a dedicated search index, but the first release could work with SQL filters because the dataset was still small. I chose a constrained SQL implementation with allowed filters, stable sorting, and pagination instead of building a full indexing pipeline immediately. I explained the limits and added metrics so we would know when the simple path stopped being enough.