Microsoft
70-450 · Question #92
70-450 Question #92: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. The solution is log-shipped for high-availability purposes. The data files of the database reside on drive D, while the transaction log files of the database reside on drive E. A restoring test plan should be implemented to satisfy the requirements listed below for the log- shipping solution. - First, the secondary database is brought online in the shortest time. - Secondly, the data is in a consistent state. - Thirdly, the data loss is reduced to the least. The first step for the recovery test plan should be identified in the event of drive D failure. Which step should be performed?
Options
- AYou should bring the secondary database online.
- BYou should execute the DBCC CHECKDB command along with the REPAIR_REBUILD
- CYou should perform the tail-log backup of the primary database.
- DYou should execute the DBCC CHECKDB command along with the
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.