SK0-004 · Question #758
A database server is configured with the database files residing on a separate partition to meet vendor recommendations. The following schedule is used for system backup: - Full backup Saturday at…
The correct answer is C. Restore the server from Tuesday's snapshot. The key constraints are: (1) restore the database to its pre-corruption state (Sunday), and (2) preserve the OS patches installed Tuesday night. Because the database files reside on a separate partition, the database and OS can be restored independently. A Tuesday snapshot…
Question
A database server is configured with the database files residing on a separate partition to meet vendor recommendations. The following schedule is used for system backup:
- Full backup Saturday at 12:00 a.m.
- Differential backup daily Sunday through Friday at 12:00 a.m.
- Database backups daily at 12:00 a.m.
New data is loaded into the database on Monday night, and OS patches are installed on Tuesday night. On Wednesday, it is discovered that the data loaded into the database on Monday is corrupted, and the database needs to be restored from Sunday's backup. Which of the following backup types would BEST allow restoration of the database without affecting the OS patches installed on Tuesday?
Options
- ARestore the differential backup from Tuesday
- BRestore the server from Saturday's full backup
- CRestore the server from Tuesday's snapshot
- DRestore the database backup from Monday
How the community answered
(38 responses)- A26% (10)
- B11% (4)
- C58% (22)
- D5% (2)
Explanation
The key constraints are: (1) restore the database to its pre-corruption state (Sunday), and (2) preserve the OS patches installed Tuesday night. Because the database files reside on a separate partition, the database and OS can be restored independently. A Tuesday snapshot captures the complete server state after the OS patches were applied Tuesday night, preserving those changes in the OS partition. From that restored snapshot, the database partition can then be separately restored from Sunday's database backup - giving a clean OS with Tuesday's patches intact and the database in its pre-corruption Sunday state. Option A (Tuesday differential) restores all changes since Saturday's full backup, including both the corrupted database data and the OS patches - you cannot surgically exclude the corrupted DB data. Option B (Saturday full backup) restores everything to Saturday, wiping out both the database changes and the Tuesday OS patches. Option D (Monday database backup, taken at 12:00 AM before the data load Monday night) would actually restore a clean database state, but it does not address preserving the Tuesday OS patches; the question asks for the BEST method to protect both concerns simultaneously.
Topics
Community Discussion
No community discussion yet for this question.