Database Replication — Concept Check
Questions on Database Replication. Database replication copies data from a primary (master) to one or more replicas (slaves). It improves read throughput, provides fault tolerance, and enables geographic distribution.
Questions in this quiz
7 questions on Database Replication — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A database system experiences high write latency. Monitoring shows that writes are waiting for replica acknowledgments. What replication method is likely being used?
- AAsynchronous replication
- BSynchronous replication
- CLeaderless replication
- DMulti-leader replication
2.During a failover, a replica is promoted to primary. Which of the following is a potential risk if using asynchronous replication?
- AImmediate consistency across replicas
- BBlocked writes if replica is down
- CData loss if the primary fails before replication
- DIncreased write latency
3.A company uses multi-leader replication across regions. What is a key challenge they must address?
- AIncreased read latency
- BSingle point of failure
- CConflict resolution between writes
- DInability to scale reads
4.A developer configures PostgreSQL with 'synchronous_commit = remote_apply'. What is the expected behavior?
- AStrongest consistency with increased latency
- BImmediate write acknowledgment
- CReduced write latency with potential data loss
- DRead and write to any node
5.A database experiences replication lag. Which monitoring command would help diagnose this in MySQL?
- ASHOW PROCESSLIST
- BSHOW SLAVE STATUS
- Cpg_stat_replication
- Dvmstat
6.A service is configured with Spring Boot read/write splitting. What happens when a read-only transaction is executed?
- AIt routes to the primary
- BIt fails due to misconfiguration
- CIt causes a deadlock
- DIt routes to the read replica
7.A team wants to ensure no data loss during failover. Which replication method should they choose?
- ALeaderless replication
- BSynchronous replication
- CAsynchronous replication
- DMulti-leader replication