Microsoft
70-450 · Question #124
70-450 Question #124: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #124. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 infrastructure. You plan to upgrade a Microsoft SQL Server 2005 instance to SQL Server 2008 by using an in- place upgrade. All user databases use the simple recovery model and have the PAGE_VERIFY option turned off. You need to ensure that the database engine can identify I/O path errors and memory corruptions for the data in tables. Which two actions should you perform before the upgrade? (Each correct answer presents part of the solution. Choose two.)
Options
- ARebuild the nonclustered indexes.
- BRebuild the clustered indexes and heaps.
- CSet the database recovery model to FULL.
- DSet the PAGE_VERIFY database option to CHECKSUM.
- ESet the PAGE_VERIFY database option to TORN_PAGE_DETECTION.
- FExecute the DBCC CHECKDB command by using the DATA_PURITY option.
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.