Data Synchronization and Consistency - Quiz #2

What is the primary goal of data synchronization?

• To increase data storage capacity.

• To ensure data is consistent across multiple locations or systems.

• To reduce network latency.

• To encrypt sensitive data.

Which concept ensures that all copies of data across a distributed system are identical at a given point in time?

• Eventual consistency

• Data replication

• Strong consistency

• Asynchronous processing

Data replication is the process of:

• Moving data from one database to another permanently.

• Creating and maintaining multiple copies of data across different locations.

• Converting data from one format to another.

• Deleting redundant data from a system.

A key benefit of data replication is:

• Reduced data storage costs.

• Improved data security against unauthorized access.

• Enhanced data availability and fault tolerance.

• Simplified database schema design.

Which type of data replication involves copying data changes as they occur, often in real-time?

• Snapshot replication

• Transactional replication

• Merge replication

• Offline replication

In a distributed transaction, what does the "Atomicity" (A in ACID) property ensure?

• That transactions are executed in a specific order.

• That concurrent transactions do not interfere with each other.

• That all operations within the transaction either complete successfully or none of them do.

• That data remains consistent after a transaction commits.

The "Two-Phase Commit (2PC)" protocol is commonly used to ensure what in distributed transactions?

• Eventual consistency

• Strong consistency

• Data replication

• Asynchronous processing

What is eventual consistency?

• Data is always immediately consistent across all replicas.

• Data will eventually become consistent across all replicas, given enough time and no new updates.

• Only a single copy of data exists at any time.

• Data consistency is not a concern.

Which type of database often prioritizes availability and partition tolerance over immediate strong consistency, typically embracing eventual consistency?

• Relational (SQL) databases

• NoSQL databases

• Mainframe databases

• Hierarchical databases

A system where users might temporarily see outdated data, but after a short period, all users will see the most recent data, demonstrates:

• Strong consistency

• Immediate consistency

• Eventual consistency

• Transactional integrity