You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The other day you have received
instructions to update a SQL Server 6.0 database to the SQL Server instance. You need to ensure
that suspect pages in CK_Prod be detected early.
What should you do?
A.
You should consider configuring the PAGE_VERIFY database selection to CHECKSUM for the database.
B.
You should consider configuring the database compatibility level option to 1.
C.
You should consider switching of the TRUSTWORTHY database selection for the database.
D.
You should consider configuring the PAGE_VERIFY database selection to TORN_PAGE_DETECTION.