70-450 · Question #67
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…
The correct answer is B. To finish the task, the full-recovery model along with transaction log backups should be. Requires log backups. - No work is lost due to a lost or damaged data file. - Can recover to an arbitrary point in time (tor example, prior to application or user error). Work loss exposure - Normally none. - It the tail of the log is damaged, changes since the most recent log…
Question
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?
Options
- ATo finish the task, hourly database snapshots should be utilized.
- BTo finish the task, the full-recovery model along with transaction log backups should be
- CTo finish the task, the full-recovery model along with differential backups should be utilized.
- DTo finish the task, the simple-recovery model along with differential backups should be
How the community answered
(30 responses)- A3% (1)
- B77% (23)
- C13% (4)
- D7% (2)
Explanation
- Requires log backups. - No work is lost due to a lost or damaged data file. - Can recover to an arbitrary point in time (tor example, prior to application or user error). Work loss exposure - Normally none. - It the tail of the log is damaged, changes since the most recent log backup must be redone. Recover to point in time - Can recover to a specific point in time, assuming that your backups are complete up to that
Topics
Community Discussion
No community discussion yet for this question.