PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform before the upgrade?

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.)

PrepAway - Latest Free Exam Questions & Answers

A.
Rebuild the nonclustered indexes.

B.
Rebuild the clustered indexes and heaps.

C.
Set the database recovery model to FULL.

D.
Set the PAGE_VERIFY database option to CHECKSUM.

E.
Set the PAGE_VERIFY database option to TORN_PAGE_DETECTION.

F.
Execute the DBCC CHECKDB command by using the DATA_PURITY option.


Leave a Reply