70-450 · Question #32
You are a professional level SQL Sever 2008 Database Administrator. A database is hosted by the instance. You can see the backup strategy utilized by the database from table listed below: A batch…
The correct answer is C. The full database backup that was performed on Thursday should be recovered. Because we want the database restored to Saturday 21:00, because the job start exactly at the same time than the full backup, we can't use it. So, we have to restore the last full backup then the differential backup and tinaly the transactions logs.
Question
You are a professional level SQL Sever 2008 Database Administrator. A database is hosted by the instance. You can see the backup strategy utilized by the database from table listed below:
A batch process is run on Saturday, and the process lasts from 21:00 hr to 23:00 hr; you find that the batch process takes no effect because certain data is modified some data by a user at 21:05 hr on the same day. The database should be recovered to its state at the start of the batch process in the shortest time. Which action will you perform?
Exhibit
Options
- AThe full database backup that was performed on Saturday should be recovered.
- BThe full database backup that was performed on Thursday should be recovered.
- CThe full database backup that was performed on Thursday should be recovered.
- DThe full database backup that was performed on Saturday should be recovered.
How the community answered
(42 responses)- A5% (2)
- B2% (1)
- C83% (35)
- D10% (4)
Explanation
Because we want the database restored to Saturday 21:00, because the job start exactly at the same time than the full backup, we can't use it. So, we have to restore the last full backup then the differential backup and tinaly the transactions logs.
Topics
Community Discussion
No community discussion yet for this question.