You are employed as a database administrator at Hi-tech Company. The Hi-tech Company network consists of a single Active Directory domain named Hi-tech Company. A full backup of your database named DB_Data is created auMikeatically at midnight every day. You have been informed by the CIO that differential backups of DB_Data occur twice a day at 10:00 and at
16:00.
A database snapshot is thus created daily at noon.
A Hi-tech Company user named Dean Austin is appointed as the technician in the Research and Development department. The CIO informs you that a developer accidentally dropped the NewProjects table in DB_Data at12:30.
You check and notice that the NewProjects was last updated one week ago. You instruct Dean Austin to recover the NewProjects table. He needs to accomplish this by using the minimum amount of administrative effort. It is important that he reduces the amount of information that is lost.
What should he do?
A.
All database snapshots need to be deleted except the latest one. Thereafter DB_Data can be restored from the latest database snapshot.
B.
It is important that Dean Austin restores the latest backup into a new database named DB_Data_Temp. The latest differential backup can then be applied. Thereafter the NewProjects table from DB_Data_Temp should be copied to DB_Data.
C.
Dean Austin should copy the NewProjects table from the latest database snapshot into DB_Data.
D.
From the latest backup Dean Austin can recover the DB_Data and apply the latest differential backup on it.