NoSQL Quiz

What does NoSQL refer to?

• Not only Structured Query Language

• Not only Simple Query Language

• New SQL

• Not only SQL

Which of the following is a characteristic of NoSQL databases?

• Schema-less data model

• Data can only exist in structured form

• Cannot scale up by adding more nodes

• Requires replacing the existing node with a higher performance one for scaling

What is the benefit of NoSQL databases being highly available?

• They require high operational costs

• They are built on single-node technologies

• They provide fault tolerance out of the box

• They are not scalable

What does BASE compliance in NoSQL databases ensure?

• Immediate consistency after a write

• High availability despite network/node failure

• ACID properties are strictly maintained

• Data is only stored on premium hardware

What is a potential cost advantage of many NoSQL databases?

• They require specialized hardware

• They have high licensing costs

• They can often be deployed on commodity hardware

• They are only available as proprietary software

What does ACID stand for in database systems?

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Clarity, Isolation, Dynamics

• Asynchronous, Concurrency, Integrity, Data-binding

• Allocation, Compression, Integration, Distribution

Which of the following is a feature of NoSQL storage devices to support horizontal scaling and high availability?

• API driven data access

• Auto sharding and replication

• Distributed query support

• Polyglot persistence

What is the primary reason for the emergence of NoSQL storage devices according to the text?

• The need for a third-party distributed caching layer

• The requirement for SQL-like query capability

• The characteristics of Big Data datasets

• The need for aggregate-focused storage devices

Which of the following is NOT a characteristic of NoSQL storage devices mentioned in the text?

• They automatically employ sharding and replication techniques

• They maintain consistent query behavior across multiple shards

• They require retiring traditional RDBMSs

• They store de-normalized aggregated data

Why do NoSQL storage devices need to be highly scalable?

• To reduce the complexity of data management

• To keep costs down and remain competitive

• To increase the speed of data processing

• To simplify the database design