When would you choose a relational database versus a NoSQL database in a system design? What are the trade-offs?

Sample answer preview

The choice between relational and NoSQL databases is one of the most common architectural decisions, and making it well requires understanding the data model, access patterns, consistency requirements, and scalability needs of your application.