Eladio Rocha
Test por , creado hace 18 días

Learn the fundamental concepts of ACID compliance and the CAP Theorem in database systems. Explore how Atomicity, Consistency, Isolation, and Durability ensure reliable transactions, and understand the trade-offs between Consistency, Availability, and Partition Tolerance in distributed databases. This guide covers real-world examples, database system behaviors, and modern approaches to scalability and fault tolerance.

3
0
0
Eladio Rocha
Creado por Eladio Rocha hace 18 días
Cerrar

ACID Compliance and CAP Theorem

ACID Compliance and CAP Theorem

Pregunta 1 de 10

1

What does Atomicity in ACID compliance ensure?

Selecciona una de las siguientes respuestas posibles:

  • Transactions are immediately readable by all users.

  • Each transaction either fully succeeds or fully fails.

  • Rules within the database are always consistently applied.

  • Data is distributed across multiple partitions.

Explicación

Pregunta 2 de 10

1

In ACID, how is Consistency defined?

Selecciona una de las siguientes respuestas posibles:

  • Data changes are immediately visible across all nodes.

  • Database rules are consistently enforced during transactions.

  • Data retrieval is consistent across replicas.

  • Transactions never conflict with each other.

Explicación

Pregunta 3 de 10

1

What is the main goal of Isolation in ACID?

Selecciona una de las siguientes respuestas posibles:

  • To allow multiple transactions to modify the same data simultaneously.

  • To prevent transactions from interfering with each other.

  • To propagate data quickly across distributed systems.

  • To write data to durable storage.

Explicación

Pregunta 4 de 10

1

What does Durability in ACID compliance guarantee?

Selecciona una de las siguientes respuestas posibles:

  • Data is stored in memory for faster access.

  • Committed data will persist even after a crash.

  • Transactions are visible across distributed systems.

  • Data propagation is eventually consistent.

Explicación

Pregunta 5 de 10

1

Which of the following is a core concept of the CAP Theorem?

Selecciona una de las siguientes respuestas posibles:

  • Scalability, Reliability, Durability

  • Availability, Partition Tolerance, Consistency

  • Atomicity, Durability, Replication

  • Redundancy, Speed, Isolation

Explicación

Pregunta 6 de 10

1

What is the trade-off when using a database like Cassandra in terms of the CAP Theorem?

Selecciona una de las siguientes respuestas posibles:

  • Sacrifices partition tolerance for strong consistency.

  • Sacrifices consistency for availability and partition tolerance.

  • Sacrifices availability for consistency and partition tolerance.

  • Provides all three: consistency, availability, and partition tolerance.

Explicación

Pregunta 7 de 10

1

What does Availability mean in the CAP Theorem?

Selecciona una de las siguientes respuestas posibles:

  • Data changes are consistently propagated immediately.

  • The system avoids single points of failure.

  • Transactions remain durable during failures.

  • Data retrieval always reflects the most recent write.

Explicación

Pregunta 8 de 10

1

What is an example of a system that sacrifices availability in favor of consistency and partition tolerance?

Selecciona una de las siguientes respuestas posibles:

  • MySQL

  • Cassandra

  • DynamoDB in eventual consistency mode

  • MongoDB

Explicación

Pregunta 9 de 10

1

How does Partition Tolerance benefit distributed databases?

Selecciona una de las siguientes respuestas posibles:

  • Ensures that no data is lost in case of system crashes.

  • Allows the system to scale horizontally across multiple servers.

  • Guarantees real-time consistency for all reads and writes.

  • Eliminates the need for replication across nodes.

Explicación

Pregunta 10 de 10

1

What is a common characteristic of modern database systems regarding CAP trade-offs?

Selecciona una de las siguientes respuestas posibles:

  • They strictly enforce the CAP Theorem limitations.

  • They provide flexibility to optimize different properties based on use cases.

  • They always prioritize availability over consistency.

  • They eliminate the need for partition tolerance entirely.

Explicación

Anterior
Siguiente