DS0-001 · Question #154
DS0-001 Question #154: Real Exam Question with Answer & Explanation
The correct answer is C: Transaction logs. Transaction logs are the go-to resource for disaster recovery because they contain a chronological record of every database operation (inserts, updates, deletes), allowing you to replay or roll back changes to restore the database to a consistent state before or after the failure
Question
Which of the following is the best to consult in order to start the recovery process after a disaster?
Options
- ABuild documentation
- BEntity relations diagram
- CTransaction logs
- DData dictionary
Explanation
Transaction logs are the go-to resource for disaster recovery because they contain a chronological record of every database operation (inserts, updates, deletes), allowing you to replay or roll back changes to restore the database to a consistent state before or after the failure point. Build documentation (A) describes how software was constructed, not how to recover data - useful for rebuilding systems but not restoring lost data. Entity relationship diagrams (B) show how data is structured and related, but contain no actual data or change history to recover from. Data dictionaries (D) define the meaning and format of data fields, which helps understand the data but can't restore it.
Memory tip: Think of transaction logs as a DVR for your database - you can rewind and replay exactly what happened, making them the "rewind button" in a disaster scenario.
Community Discussion
No community discussion yet for this question.