Microsoft
70-450 · Question #99
70-450 Question #99: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance that hosts a large database. The database experiences high volumes of queries and transactions that are processor-intensive. You plan to implement an incremental backup strategy for the database. You also plan to use backup compression. You need to ensure that the backup jobs have a minimal effect on the performance of the server. What should you do?
Options
- AUse database snapshots.
- BUse the Resource Governor.
- CReconfigure the Affinity I/O Mask configuration option.
- DSpread the database backup across multiple backup devices.
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.