You are a professional level SQL Sever 2008 Database Administrator. A large database is
hosted by the instance. High volumes of queries and transactions that are processor
intensive are experienced by the database. An incremental backup strategy should be
designed for the database. In addition, backup compression will be utilized. Since you are
the technical support of the company, you are required to reduce the impact from the
backup jobs on the performance of the server to the least. Which action will you perform to
achieve the goal?
A.
To achieve the goal, the Affinity I/O Mask configuration option should be reconfigured.
B.
To achieve the goal, the database backup should be spread across multiple backup
devices.
C.
To achieve the goal, database snapshots should be utilized.
D.
To achieve the goal, the Resource Governor should be utilized.