You are a professional level SQL Sever 2008 Database Administrator. All data changes are
implemented through stored procedures, and only the INSERT, UPDATE, or DELETE
statements are utilized by the procedures. A backup strategy should be implemented. The
business requirements listed below should be satisfied: Point-in-time recovery for failure
is supported by the backup strategy at any time of day. The least amount of disk space
should be utilized by the transaction log. Which action should you perform to finish the task?
A.
To finish the task, the full-recovery model along with transaction log backups should be
utilized.
B.
To finish the task, the full-recovery model along with differential backups should be
utilized.
C.
To finish the task, hourly database snapshots should be utilized.
D.
To finish the task, the simple-recovery model along with differential backups should be
utilized.