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 should be managed by you.
The computer on which the instance run has the following three features:
a 64-GB RAM, four quad-core processors, and several independent physical raid volumes A transactional database will be implemented on the instance. In addition, the database should have a high volume of INSERT, UPDATE, and DELETE activities.
Creation of new tables is contained by the activities.
You need to maximize disk bandwidth and decrease the contention in the storage allocation structures so as to have the performance of the database optimized.
Which action will you perform to finish the task?
A.
To finish the task, database and log files should be placed on the same volume.
B.
To finish the task, the affinity mask option should be configured properly.
C.
To finish the task, multiple data files should be create for the database.
D.
To finish the task, the affinity I/O mask option should be configured properly.