Microsoft
70-432 · Question #227
You administer a Microsoft SQL Server 2008 R2 instance. You need to rectify a damaged index without losing any data. What should you do?
The correct answer is E. Execute DBCC CHECKDB along with the REPAIR_REBUILDcla.se. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 instance. You need to rectify a damaged index without losing any data. What should you do?
Options
- AExecute sp_helpfile.
- BExecute DBCC CHECKDB.
- CExamine the msdb..suspect_pagestable.
- DExecute DBCC CHECKDBalong with the REPAIR_FASTclause.
- EExecute DBCC CHECKDB along with the REPAIR_REBUILDcla.se
- FRestore the database from the most recent full backup.
- GUse the ALTER DATABASEstatement along with the SET EMERGENCYclause.
- HUse the RESTORE DATABASEstatement along with the PAGESclause.
How the community answered
(19 responses)- C5% (1)
- E84% (16)
- F11% (2)
Community Discussion
No community discussion yet for this question.