Microsoft
70-432 · Question #212
70-432 Question #212: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #212. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2008 R2 instance. The database has been marked as suspect. You need to place the database into an EMERGENCY state for troubleshooting. 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 CHECKDBalong with the REPAIR_REBUILDclause.
- FRestore the database from the most recent full backup. Apply any differential and log backups.
- GUse the ALTER DATABASEstatement along with the SET EMERGENCYclause.
- HUse the RESTORE DATABASEstatement along with the PAGESclause.
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.