You are the administrator of your company network. And you’re in charge of SQL Server 2008 instance.
Now you intend to deploy a new database which asks for capacity requirements. It requires 280 GB for the database data file and 50 GB for the transaction log file. The storage array has six disk drives available for the database. The capacity of the six disk drives are all 100 GB and are attached to a redundant array of independent disks (RAID) controller which supports RAID levels 0,1, 5, and 10. You have to optimize the write performance of the transactional log.
And you also have to protect the database and transaction log files if a drive failure occurs. You have to design the storage system. So which storage configuration should you use?
A.
A single RAID 5 volume
B.
A single RAID 10 volume
C.
A RAID 1 volume and a RAID 5 volume
D.
A RAID 0 volume and a RAID 5 volume