You are a professional level SQL Sever 2008 Database Administrator. The computer on
which the instance run has the following three features: 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.