Databases · Middle · Question 54 of 75
What is a key difference between SQL and NoSQL scaling, as usually described?
- 1SQL databases can't run on more than one server
- ✓Correct answer: Many NoSQL systems are built to partition data across nodes from the start; relational databases traditionally scale up and add read replicas
- 3NoSQL databases never need indexes
Explanation
The line is blurry now: Citus, CockroachDB and others shard SQL, and NoSQL systems add transactions. Choose by data model and access patterns.