Microsoft
70-450 · Question #114
70-450 Question #114: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #114. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 infrastructure. A SQL Server instance contains a transactional database. You design a plan to back up and restore a database. The current transactional database backup strategy has the following features: You simulate a complete hardware failure at 15:29 hr on Monday. The test includes inconsistent application data beginning at 15:00 hr. You need to ensure that you can restore the database up You need to ensure that the backup jobs have a minimal effect on the performance of the server to 15:00 hr on Monday. Which three steps should you perform? (Each correct answer presents part of the solution. Choose three.)
Options
- ARestore the differential backups from Monday.
- BRestore the differential backups from Sunday.
- CRestore log backups from Monday 02:15 hr to 15:15 hr by using the STANDBY option.
- DRestore the full back up from Saturday.
- ERestore log backups from Monday 02:15 hr to 15:15 hr by using the STOPAT Option.
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.