Microsoft
70-450 · Question #32
70-450 Question #32: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #32. The question stem and answer options stay visible for context.
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.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.