Microsoft
70-432 · Question #101
You are the administrator of a SQL Server 2008 instance. The instance contains a database named Finance. The recovery model of the Finance database is set to Full. You deploy a new process that…
The correct answer is A. Database snapshots. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. The instance contains a database named Finance. The recovery model of the Finance database is set to Full. You deploy a new process that modifies 10,000 records from the Accounts table at 19:00 hours daily. You need to ensure that any modification to the data can be reverted without the database going offline. Which strategy should you implement?
Options
- ADatabase snapshots
- BDifferential backup
- CTransaction log backup
- DPrimary filegroup backup
How the community answered
(25 responses)- A80% (20)
- B4% (1)
- C4% (1)
- D12% (3)
Community Discussion
No community discussion yet for this question.