DS0-001 · Question #98
DS0-001 Question #98: Real Exam Question with Answer & Explanation
The correct answer is B: Checkpoints. Checkpoints reduce log-based recovery overhead by periodically saving a snapshot of the database's current state to disk, so during recovery the system only needs to replay log entries from the last checkpoint forward - not the entire log history. Deadlocks (A) are a concurrency
Question
A database manager would like to reduce the overhead caused by log-based recoveries. Which of the following should the manager use to best mitigate the situation?
Options
- ADeadlocks
- BCheckpoints
- CLocks
- DIndexes
Explanation
Checkpoints reduce log-based recovery overhead by periodically saving a snapshot of the database's current state to disk, so during recovery the system only needs to replay log entries from the last checkpoint forward - not the entire log history. Deadlocks (A) are a concurrency problem where transactions block each other indefinitely; they have nothing to do with recovery efficiency. Locks (C) control concurrent access to data and prevent conflicts, but they don't affect how much work a recovery process must do. Indexes (D) speed up query lookups but play no role in the recovery mechanism at all.
Memory tip: Think of a checkpoint like a "save game" in a video game - when you restart after a crash, you reload from the last save point rather than replaying everything from the beginning.
Community Discussion
No community discussion yet for this question.