Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Choose Storage for Search History

MediumExecution00:00
Practice interviewer
In session
5 left
00:00

Your question is Choose Storage for Search History. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

Scenario

You’re designing how a conversational search product should store and retrieve user search history across web and mobile surfaces. The history needs to support fast timeline views, thread-level retrieval, deletion requests, and future features like personalization and analytics. You want to choose between a SQL system, a NoSQL system, or a hybrid approach before the team commits to implementation.

Question

How would you analyze the trade-offs between SQL and NoSQL databases for storing and retrieving conversational search history?