Solved

A Database Server Is Configured with the Database Files Residing

Question 442

Multiple Choice

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?


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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions