You are a database administrator for AIOTestKing.com. You are configuring a new SQL Server 2005 computer. The computer contains five hard disks. You need to ensure that the server can continue functioning in the event that a single hard disk fails. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Configure a non-RAID volume that uses one hard disk.Install Microsoft Windows Server 2003 and SQL Server on the non-RAID volume.
B.
Configure a RAID-1 volume that uses two hard disks.Install Microsoft Windows Server 2003 and SQL Server on the RAID-1 volume.
C.
Configure a RAID-5 volume that uses four hard disks.Place the transaction log and data files on the RAID-5 volume.
D.
Configure a RAID-5 volume that uses three hard disks.Place the transaction log and data files on the RAID-5 volume.
E.
Configure a RAID-0 volume that uses three hard disks.Place the transaction log and data files on the RAID-0 volume.
Explanation:
By creating a mirrored disk set (RAID-1) for the OS and the SQL Server installation you ensure that there is a copy of the installation if a hard disk error occurs. By putting the data and transaction logs on a Striped set with parity (RAID-5) you ensure that the data is available even if one of the three disks in the RAID-5 configuration crashes. RAID-0 or non-RAID volumes provides no fault tolerance. And configuring a RAID-5 over 4 disks would mean that you have to use one non-RAID volume.