Microsoft
70-450 · Question #94
70-450 Question #94: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance that hosts a large database. The following backup strategy is used for the database: - A full database backup is performed at 02:00 hr every Monday. - A differential backup is performed at 23:00 hr every day. - A transaction log backup is performed on an hourly basis. - A power failure on Thursday causes the SQL Server 2008 server to restart at 09:15 hr. Fifteen minutes after the server restarts, the users report that they are unable to execute certain queries that access customer data. You discover that the customer data is unmodified after the power failure. When you execute the DBCC CHECKDB command on the database, you receive the following error message: You need to ensure that the data is available as quickly as possible with minimal effect on users. What should you do?
Exhibit
Options
- ADrop and recreate the PK index.
- BDrop and recreate the NCIX index.
- CRestore the latest full database backup.
- DRestore the latest full database backup.
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.