Microsoft
70-432 · Question #196
70-432 Question #196: Real Exam Question with Answer & Explanation
The correct answer is H. Restore the backups taken Wednesday, Friday, and Saturday.. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders. The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table: A drive fails and the CustomerOrders database goes into suspect mode on Sunday at 09:00 hours. You need to restore the backup. What should you do?
Exhibit
Options
- ARestore the backup taken on Sunday only.
- BRestore the backups taken on Sunday and Monday.
- CRestore the backup taken on Wednesday only.
- DRestore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
- ERestore the backups taken on Wednesday and Thursday at 09:00 hours.
- FRestore the backups taken on Wednesday, Thursday, and Friday.
- GRestore the backups taken on Wednesday and Friday.
- HRestore the backups taken Wednesday, Friday, and Saturday.
Community Discussion
No community discussion yet for this question.