CompTIA Server+ (SK0-004) — Question 28

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?

Answer options

• A. Restore the differential backup from Tuesday
• B. Restore the server from Saturday's full backup
• C. Restore the server from Tuesday's snapshot
• D. Restore the database backup from Monday

Correct answer: C

Explanation

The correct answer is C, as restoring the Tuesday snapshot allows the database to be reverted to its state before the corrupted data was added, without impacting the OS patches. Option A would not work because it depends on the differential backup that includes the corrupted data. Option B would revert the entire server, losing the OS changes made on Tuesday. Option D would restore the corrupted data, which is not the desired outcome.