Microsoft
70-432 · Question #99
You are the administrator of a SQL Server 2008 instance with a database named Finance. Minimally logged operations are performed on the Finance database. You need to verify that the database can be…
The correct answer is B. Verify that the database uses the simple recovery model. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named Finance. Minimally logged operations are performed on the Finance database. You need to verify that the database can be restored to a specific point in time. What should you do?
Options
- AVerify that the database uses the full recovery model
- BVerify that the database uses the simple recovery model.
- CVerify that the database uses the bulk-logged recovery model.
- DVerify that the database uses the checksum page verify option.
How the community answered
(20 responses)- A5% (1)
- B80% (16)
- C5% (1)
- D10% (2)
Community Discussion
No community discussion yet for this question.