Microsoft
70-432 · Question #46
You are the administrator of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you have to…
The correct answer is B. For the database, the PAGE_VERIFY database option should be set to CHECKSUM. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you have to make sure that suspect pages can be detected in the database. Which action should you perform to achieve this goal?
Options
- AFor the database, you should turn on the TRUSTWORTHY database option
- BFor the database, the PAGE_VERIFY database option should be set to CHECKSUM
- CFor the database, the database compatibility level option should be set to 10.
- DFor the model database, the PAGE_VERIFY database option should be set to
How the community answered
(47 responses)- A4% (2)
- B81% (38)
- C13% (6)
- D2% (1)
Community Discussion
No community discussion yet for this question.