C90-02 practice question 15 of 15

Because non-relational cloud storage avoids the processing overhead that can be imposed by relational databases, it can be more scalable.

Full set: 89 questions
Answer options
A: True
B: False
Correct Answer:
[TRUE]
Explanation

The statement is correct. Non-relational (NoSQL) storage systems are fundamentally designed to prioritize horizontal scalability and high availability, often for large, distributed datasets. They achieve this by avoiding the architectural constraints and associated processing overhead inherent in traditional relational database management systems (RDBMS). This overhead in RDBMS includes enforcing strict schemas, maintaining data integrity through foreign keys, ensuring ACID (Atomicity, Consistency, Isolation, Durability) compliance for transactions, and processing complex, multi-table JOIN operations. By relaxing these requirements (e.g., adopting flexible schemas and eventual consistency models like BASE), non-relational systems reduce computational complexity, allowing them to scale out more efficiently and cost-effectively across many commodity servers.

Why Incorrect

The "False" option is incorrect because the relationship between reduced processing overhead and increased scalability is a foundational principle distinguishing non-relational from relational database architectures. The design choices made in non-relational systems (e.g., schema-on-read, denormalization, BASE consistency) are deliberate trade-offs made specifically to eliminate the performance bottlenecks that limit the horizontal scalability of traditional relational systems.

References

1. Erl, T., Puttini, R., & Mahmood, Z. (2013). Cloud Computing: Concepts, Technology & Architecture. Prentice Hall. In Chapter 6.4, Cloud Storage Devices, the text explains that non-relational storage is "unfettered by the processing overhead and structural limitations of relational databases" and that this design "can be more scalable" (pp. 178-179).

2. Cattell, R. (2011). Scalable SQL and NoSQL data stores. ACM SIGMOD Record, 39(4), 12–27. https://doi.org/10.1145/1978915.1978919. Section 3, "The NoSQL Movement," discusses how NoSQL systems achieve better scalability by relaxing the strict consistency guarantees (ACID) of traditional RDBMS, which are a primary source of processing overhead and performance bottlenecks in distributed environments.

3. Abadi, D. J. (2012). Consistency Tradeoffs in Modern Distributed Database System Design. Computer, 45(2), 37-42. https://doi.org/10.1109/MC.2012.33. This paper from a Yale University professor elaborates on the CAP theorem, explaining that traditional relational databases prioritize Consistency, which imposes significant overhead (e.g., two-phase commit protocols) that hinders scalability. NoSQL systems often trade strong consistency for higher availability and partition tolerance, enabling greater scalability.

Scroll to Top