QCM : Understanding NoSQL: Scalability and Data Models — 9 questions

Question 1

1. How does the CAP Theorem differentiate between consistency and availability in distributed systems?

During a network partition, systems must choose to prioritize either consistency or availability, but not both.

The CAP Theorem states that distributed systems can only guarantee either consistency or partition tolerance, but not availability.

Consistency and availability are independent properties that can be guaranteed simultaneously regardless of network partitions.

Systems can guarantee both consistency and availability simultaneously during network partitions.

Explication

The CAP Theorem states that in the presence of a network partition, a distributed system must choose between providing consistency or availability. It cannot guarantee both simultaneously, which is why systems must prioritize one over the other during such failures.

Answer

During a network partition, systems must choose to prioritize either consistency or availability, but not both.

Question 2

2. What does NOSQL stand for and what is its primary design focus?

Not Only SQL; designed for large-scale, distributed data with flexible schemas.

New SQL; focused on traditional relational database features.

Not Only SQL; aimed solely at improving relational databases.

Numerical Only SQL; optimized for scientific data processing.

Explication

NOSQL stands for Not Only SQL and is designed for handling large-scale, distributed data with flexible schemas, making it suitable for modern web and cloud applications.

Answer

Not Only SQL; designed for large-scale, distributed data with flexible schemas.

Question 3

3. What is the primary role of horizontal scaling methods in distributed database systems?

To ensure data consistency through strict transactional protocols

To improve data security through encryption and access controls

To simplify data models by reducing the number of tables or collections

To increase the capacity and performance by distributing data across multiple servers

Explication

Horizontal scaling methods such as sharding and replication are used to increase capacity and performance by distributing data and workload across multiple servers, enabling systems to handle larger datasets and higher traffic efficiently.

Answer

To increase the capacity and performance by distributing data across multiple servers

Question 4

4. Which property of the CAP theorem is typically sacrificed in many NOSQL systems to achieve high availability?

Consistency

Availability

Partition Tolerance

All three properties are equally guaranteed.

Explication

Many NOSQL systems prioritize availability over strong consistency, especially in partitioned networks, leading to models like eventual consistency, as dictated by the CAP theorem.

Answer

Availability

Question 5

5. What does NOSQL refer to in the context of databases?

A traditional SQL-based database system with fixed schemas

A database system that exclusively uses XML for data storage

A class of relational databases optimized for complex joins

A type of non-relational database designed for scalability and flexible schemas

Explication

NOSQL refers to a class of non-relational databases that are designed to handle large-scale, distributed data with flexible schemas, offering high scalability and performance. Unlike traditional relational databases, NOSQL systems do not rely on fixed schemas or SQL for data management.

Answer

A type of non-relational database designed for scalability and flexible schemas

Question 6

6. Which type of NOSQL database is best suited for modeling complex relationships and interconnectivity?

Graph-based databases

Key-Value databases

Document databases

Column-family databases

Explication

Graph-based NOSQL databases like Neo4j are optimized for modeling complex relationships and interconnectivity between data points.

Answer

Graph-based databases

Question 7

7. What is a key characteristic that differentiates schema-less data storage from traditional relational databases?

Data stored without a fixed schema, allowing dynamic data models.

Data must follow a strict, predefined structure.

It only supports key-value pairs.

Data is stored using tabular formats with fixed columns.

Explication

Schema-less data storage allows data to be stored without a fixed schema, providing flexibility to adapt data models dynamically, unlike traditional relational databases.

Answer

Data stored without a fixed schema, allowing dynamic data models.

Question 8

8. Which key-value database is known for offering fast, scalable, and simple data access, often used in distributed environments?

Redis

MongoDB

Cassandra

Neo4j

Explication

Redis is a popular key-value store favored for its speed, scalability, and simplicity, making it suitable for distributed systems.

Answer

Vertical scaling involves upgrading a single machine; horizontal scaling adds more machines or nodes.

Question 9

9. What is the main difference between vertical scaling and horizontal scaling in database systems?

Vertical scaling adds more machines; horizontal scaling upgrades the hardware of a single machine.

Vertical scaling involves upgrading a single machine; horizontal scaling adds more machines or nodes.

Vertical scaling is cheaper; horizontal scaling is always more expensive.

They are two terms for the same process.

Explication

Vertical scaling involves enhancing a single machine's resources, while horizontal scaling increases capacity by adding more machines or nodes, which is more suitable for large, distributed data systems.

QCM : Understanding NoSQL: Scalability and Data Models — 9 questions

Questions et réponses du QCM

1. How does the CAP Theorem differentiate between consistency and availability in distributed systems?

2. What does NOSQL stand for and what is its primary design focus?

3. What is the primary role of horizontal scaling methods in distributed database systems?

4. Which property of the CAP theorem is typically sacrificed in many NOSQL systems to achieve high availability?

5. What does NOSQL refer to in the context of databases?

6. Which type of NOSQL database is best suited for modeling complex relationships and interconnectivity?

7. What is a key characteristic that differentiates schema-less data storage from traditional relational databases?

8. Which key-value database is known for offering fast, scalable, and simple data access, often used in distributed environments?

9. What is the main difference between vertical scaling and horizontal scaling in database systems?

Révisez avec les flashcards

Approfondir avec la fiche

Cours similaires

Introduction à l'Intelligence Artificielle Symbolique

Introduction aux documents et sécurité en construction

Introduction à l'Informatique et IA

Introduction aux marchés publics et réglementations du bâtiment

Gestion des imprimantes Windows et PDF

Introduction aux bases de données relationnelles

Crée tes propres QCM