What do you consider when deciding whether to use a NoSQL solution instead of an SQL one?
By asking this question, the interviewer can understand several things about you. The first is your knowledge of databases, especially SQL databases. Second, your answer will also confirm if you have experience working with both SQL and NoSQL databases. The third thing the interviewer will learn is your ability to organize your thinking and present technology and options to the organization's business unit leaders. To demonstrate this, you should keep your answer direct and to the point and use simple, non-technical language when describing the benefits of each of these options.
"Both SQL and NoSQL databases have their advantages. Some of the reasons for using a NoSQL database are that the data models are flexible, scale horizontally, accelerate the queries, and are easier for developers to work with. NoSQL works better when the datasets are small and uncomplicated. When using very large datasets or data that several different applications will access, SQL databases will perform better even though they are more complex and require additional overhead."
