Intermediate
Database Management Systems
Q60 / 100
What is the difference between SQL and NoSQL databases for scalability?
Correct! Well done.
Incorrect.
The correct answer is B) SQL databases scale vertically (bigger server) more naturally; NoSQL databases are designed for horizontal scaling across many commodity nodes
B
Correct Answer
SQL databases scale vertically (bigger server) more naturally; NoSQL databases are designed for horizontal scaling across many commodity nodes
Explanation
SQL ACID constraints make distributed horizontal scaling hard (distributed transactions are expensive). NoSQL (Cassandra, DynamoDB) sacrifices strong consistency for linear horizontal write scaling.
Progress
60/100