When would you choose relational storage over a document database for a new application?
Interactive Practice Mode
Formulate your thoughts or take notes before revealing the model solution.
Saved automatically
Model Answer & Deep-Dive Explanation
Start with data relationships, transaction boundaries, integrity requirements, query patte s, and operational skills. Relational storage often fits strongly related entities and cross-entity constraints, while a document model can fit independently accessed aggregates with evolving nested structure. Both categories have products with overlapping capabilities, so avoid claims that one cannot transact or scale. Prototype the hardest queries and updates, estimate data growth, and consider indexing, migrations, backups, and failure behavior. Choose based on concrete requirements rather than adopting a database because its category sounds newer.
Related Questions in Database
DBA Interview Questions
Intermediate level • 740 views
MS-SQL Server developer interview questions
Advanced level • 260 views
MySQL management interview questions
Beginner level • 165 views
Why can a replica return stale data immediately after a successful write?
Medium level • 2 views
What is normalization, and when might denormalization be justified?
Easy level • 1 views