nerdexam
Microsoft

70-433 · Question #62

You are the administrator of a SQL Server 2008 instance with a database named DB1. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database…

The correct answer is D. You should restore both the full backup and the differential backup. See the full explanation below for the reasoning.

Question

You are the administrator of a SQL Server 2008 instance with a database named DB1. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. Which action should you perform to achieve this goal?

Options

  • AYou should restore the full backup
  • BYou should restore the database snapshot from 16:30 hours.
  • CYou should restore the database snapshot from 17:30 hours
  • DYou should restore both the full backup and the differential backup.

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    9% (3)
  • C
    3% (1)
  • D
    86% (30)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice