How do you decide between a relational database and a NoSQL database for a new system?

Interview Question

What the interviewer is testing

Workload modeling
Consistency reasoning
Operational trade-offs

Real-World Sample Answer

I would approach “How do you decide between a relational database and a NoSQL database for a new system?” by clarifying the requirements first, then using these considerations: in a real interview, i would not jump straight to a technology choice. for “how do you decide between a relational database and a nosql database for a new system?”, i would first clarify access patterns and transaction requirements. then i would estimate scale, latency, and growth and consider consistency, relationships, and query flexibility. i would also compare operational burden, availability, and cost. finally, i would choose the simplest option that meets the requirements. i would make the assumptions explicit and explain what evidence or production signals would make me revisit the decision.. I would state my assumptions and defend the trade-offs rather than presenting the choice as universally correct.

What a Strong Answer Should Cover

In a real interview, I would not jump straight to a technology choice. For “How do you decide between a relational database and a NoSQL database for a new system?”, I would first clarify access patterns and transaction requirements. Then I would estimate scale, latency, and growth and consider consistency, relationships, and query flexibility. I would also compare operational burden, availability, and cost. Finally, I would choose the simplest option that meets the requirements. I would make the assumptions explicit and explain what evidence or production signals would make me revisit the decision.

Common Mistakes

Choosing NoSQL solely because the system is large
Ignoring access patterns
Treating database choice as a technology preference

Interviewer Follow-ups

What assumptions would you clarify before committing to the design?
What changes if the scale, reliability target, security requirement, or budget changes?
What is the biggest failure mode in your proposed approach?

Use the Interview Preparation learning paths and related site content to deepen any topic you could not confidently explain.