Microsoft
70-433 · Question #59
You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the…
The correct answer is B. You should verify that the full recovery model is used by the database. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. Which action should you perform to achieve this goal?
Options
- AYou should verify that the simple recovery model is used by the database
- BYou should verify that the full recovery model is used by the database.
- CYou should verify that the checksum page verify option is used by the database
- DYou should verify that the bulk-logged recovery model is used by the database
How the community answered
(26 responses)- A15% (4)
- B77% (20)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.