Multiple ChoiceBeginner 45s
WAL durability on crash
What is the primary guarantee a write-ahead log provides on crash recovery?
Options
- 1It compresses data pages before flushing them, which reduces read amplification rather than providing durability for commits
- 2It eliminates the need for fsync on commit, since the log already guarantees durability without forcing data to stable storage
- 3It records changes durably before the data pages are written, enabling redo of committed transactions
- 4It guarantees zero data loss even for asynchronous replicas, since the log path waits for every follower to ack each record
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.