AWS Technical Essentials Practice

Which statement is true regarding NoSQL and SQL databases?

1. NoSQL and SQL support ACID properties

2. NoSQL and SQL are relational databases

3. NoSQL and SQL handle transactions

4. NoSQL and SQL implement dynamic schemas

The correct answer is: NoSQL and SQL handle transactions

The statement that NoSQL and SQL databases handle transactions is accurate when discussing their capabilities. Both database types have mechanisms for managing transactions, but they do so in different ways that align with their underlying architectures. SQL databases, known as relational databases, traditionally provide robust transaction support through ACID (Atomicity, Consistency, Isolation, Durability) properties. This ensures that transactions are processed reliably. On the other hand, many NoSQL databases have also evolved to support transactional capabilities, although their approach may deviate from the strict adherence to ACID by focusing on BASE (Basically Available, Soft state, Eventually consistent) principles. Some NoSQL systems implement features that allow for transaction-like support across multiple operations or even within a single document, providing flexibility for applications that sometimes require this functionality. The other statements, while they touch on concepts relevant to database technologies, do not accurately reflect the behaviors of NoSQL and SQL databases. For example, while some NoSQL databases may offer dynamic schemas, SQL databases typically have static schemas defined by their relational structure. Similarly, NoSQL databases do not inherently support all ACID properties in the same way that traditional SQL databases do, nor can they both be categorized strictly as relational. Thus, the handling of transactions is