QuizzesDatabase Replication — Concept Check
intermediate
system-design

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.

7 minutes 7 questions Pass at 70%
Time Limit
7 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

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. 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. 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. 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. 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. 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. 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. 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