Trade-offs with NoSQL Databases:
NoSQL databases are designed toscale horizontallyby adding more nodes rather than scaling vertically by increasing hardware capacity. To achieve this scalability andhigh availability, NoSQL systems often adopt theBASE model(Basically Available, Soft state, Eventually consistent) rather than the strictACID model (Atomicity, Consistency, Isolation, Durability) typical of relational databases.
* This means thatdata consistencymay be relaxed (eventual consistency) to allow faster reads and writes.
* These characteristics make NoSQL suitable forlarge-scale, distributed systemsbut less ideal for applications requiringimmediate consistency, such as banking systems.
Why the other options are incorrect:
* A:NoSQL does not guarantee stronger consistency than relational databases.
* C:NoSQL typically does not offer superior data integrity for transactional workloads.
* D:SQL-based querying is usually not available in NoSQL, as they often have their own query mechanisms.