Automatic Failover Policies Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Replication Strategy

What you'll be asked

  1. What is the primary purpose of an automatic failover policy in a replicated database environment?
  2. In a distributed system, what is the 'split-brain' scenario that automatic failover policies aim to prevent?
  3. When configuring a failover timeout (often called 'heartbeat timeout'), what is the risk of setting the value too low?
  4. Which mechanism is most effective at preventing accidental failovers during temporary network partitions in a multi-node cluster?
  5. In a synchronous replication setup, why must the failover policy account for the 'last committed transaction' before promoting a standby?

Answers and explanations come after you submit.