Microsoft
70-432 · Question #199
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…
The correct answer is C. Restore the backup taken on Wednesday only. 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 Monday at 09:00 hours. You need to restore the backup. What should you do?
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.
How the community answered
(40 responses)- A5% (2)
- C83% (33)
- D8% (3)
- F3% (1)
- G3% (1)
Community Discussion
No community discussion yet for this question.