Practice
1. A critical database cluster must failover automatically without data loss or downtime during a primary node crash. Which component is responsible for orchestrating this failover in a distributed SQL database system?
easy
Solution
Step 1: Identify failover orchestration component
The consensus protocol like Raft manages leader election and ensures log replication consistency, enabling automatic failover without data loss.Step 2: Eliminate other options
Client-side retries (A) handle reconnection but don't orchestrate failover; load balancers (B) redirect traffic but don't manage state; backups (D) aid recovery but not live failover.Final Answer:
Option A -> Option AQuick Check:
Consensus protocol controls leader election and failover [check]
Hint: Consensus protocols manage failover, not clients or load balancers
Common Mistakes:
2. You must design a multi-primary replication system for a geo-distributed database with low write latency and conflict detection. Which approach is best?
medium
Solution
Step 1: Analyze latency and conflict requirements
Low write latency requires asynchronous replication; conflict detection needs metadata like vector clocks.Step 2: Evaluate options
Synchronous replication (A) adds latency; single primary (C) violates multi-primary requirement; last-write-wins (D) ignores conflicts.Final Answer:
Option A -> Option AQuick Check:
Async replication + vector clocks -> low latency + conflict detection [check]
Hint: Vector clocks detect conflicts in async multi-primary [check]
Common Mistakes:
3. Without the Rendezvous Hashing component in a distributed cache, what exactly breaks when a node fails?
medium
Solution
Step 1: Understand role of Rendezvous Hashing in failure
Rendezvous Hashing provides deterministic mapping without central coordination. Without it, no automatic remapping occurs.Step 2: Trace failure impact
Without Rendezvous Hashing, system blocks or requires manual remapping, causing request blocking and downtime.Final Answer:
Option B -> Option BQuick Check:
No automatic remapping -> system blocks until manual config [check]
Hint: No Rendezvous -> manual remap blocks requests [check]
Common Mistakes:
4. If Zookeeper's session timeout mechanism fails to detect a crashed leader node promptly, what is the most likely failure observed in the leader election process?
medium
Solution
Step 1: Understand session timeout role
Session timeout detects leader failure by ephemeral node removal.Step 2: Failure of timeout detection
If timeout fails, ephemeral node remains, so followers do not start election; no split-brain occurs.Final Answer:
Option B -> Option BQuick Check:
Backup election mechanisms prevent split-brain despite timeout failure [check]
Hint: Session timeout failure -> ephemeral node stays -> no immediate election [check]
Common Mistakes:
5. At 10x traffic scale, which component is most likely to fail first in a system without rate limiting, and why?
hard
Solution
Step 1: Analyze component scalability at 10x traffic
Databases (A) and caches (D) can be scaled horizontally or sharded; load balancers (C) can be scaled or replaced with L4/L7 solutions.Step 2: Identify API servers as bottleneck
API servers maintaining stateful connections (e.g., WebSockets) are hard to shard or move; connection limits cause saturation and failure first.Final Answer:
Option D -> Option DQuick Check:
Stateful API servers hit connection limits first at scale [check]
Hint: Stateful API servers fail first due to connection limits [check]
Common Mistakes:
