70-450 · Question #99
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…
The correct answer is B. Use the Resource Governor. Resource governor can be used to limit the resource usage of a given session. Database snapshots are not a backup methodology, as they rely on the existing database. The affinity mask I/O option is for binding disk operations to certain CPUs and was covered Spreading backups…
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.
How the community answered
(22 responses)- A5% (1)
- B73% (16)
- C14% (3)
- D9% (2)
Explanation
Resource governor can be used to limit the resource usage of a given session. Database snapshots are not a backup methodology, as they rely on the existing database. The affinity mask I/O option is for binding disk operations to certain CPUs and was covered Spreading backups across multiple devices is supported in SQL Server 2008. If the resource in demand was disk I/O, this would be a viable solution.
Topics
Community Discussion
No community discussion yet for this question.