You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. And a large database is hosted by the instance.
High volumes of queries and transactions that are processorintensive 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, database snapshots should be utilized.
B.
To achieve the goal, the Affinity I/O Mask configuration option should be reconfigured.
C.
To achieve the goal, the database backup should be spread across multiple backup devices.
D.
To achieve the goal, the Resource Governor should be utilized.