Microsoft
70-450 · Question #67
70-450 Question #67: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #67. The question stem and answer options stay visible for context.
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
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.