40083361
Description
Quiz by Eladio Rocha, updated 18 days ago
|
Created by Eladio Rocha
18 days ago
|
|
Question 1
Question
What does Atomicity in ACID compliance ensure?
Answer
-
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.
Question 2
Question
In ACID, how is Consistency defined?
Answer
-
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.
Question 3
Question
What is the main goal of Isolation in ACID?
Answer
-
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.
Question 4
Question
What does Durability in ACID compliance guarantee?
Answer
-
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.
Question 5
Question
Which of the following is a core concept of the CAP Theorem?
Answer
-
Scalability, Reliability, Durability
-
Availability, Partition Tolerance, Consistency
-
Atomicity, Durability, Replication
-
Redundancy, Speed, Isolation
Question 6
Question
What is the trade-off when using a database like Cassandra in terms of the CAP Theorem?
Answer
-
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.
Question 7
Question
What does Availability mean in the CAP Theorem?
Answer
-
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.
Question 8
Question
What is an example of a system that sacrifices availability in favor of consistency and partition tolerance?
Answer
-
MySQL
-
Cassandra
-
DynamoDB in eventual consistency mode
-
MongoDB
Question 9
Question
How does Partition Tolerance benefit distributed databases?
Answer
-
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.
Question 10
Question
What is a common characteristic of modern database systems regarding CAP trade-offs?
Answer
-
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.
Want to create your own Quizzes for free with GoConqr? Learn more.