Microsoft
70-432 · Question #177
70-432 Question #177: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #177. The question stem and answer options stay visible for context.
Question
You maintain a SQL Server 2008 instance. You discover that the database named CityPowerLightDB presents data integrity problems. You perform a full database backup at 22:00 hours. The SQL Server instance experiences a power failure at 05:59 hours. No data modifications have occurred after the backup. When the database is online, you discover that some table data pages are corrupt. You need to completely repair the database in the minimum amount of time. What should you do?
Options
- ARestore the corrupt pages from the full database backup.
- BRestore the database from the full database backup.
- CUse the DBCC CHECKTABLE command along with the PHYSICAL_ONLY option.
- DUse the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.