PrepAway - Latest Free Exam Questions & Answers

Which strategy should you implement?

You maintain an instance of Microsoft SQL Server 2008. 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?

PrepAway - Latest Free Exam Questions & Answers

A.
Database snapshots

B.
Differential backup

C.
Transaction log backup

D.
Primary filegroup backup


Leave a Reply