1. You are designing a new database server for your company. You wish to store the
database’s MDF file and NDF files on the most cost efficient storage possible,
while providing a redundant storage solution. Your database will be 95% reads,
and 5% writes. What RAID level should you use for your MDF and NDF files?
A. RAID 0
B. RAID 1
C. RAID 5
D. RAID 10
Answer C is the correct answer. Although RAID 0 is more cost effective than
RAID 5, RAID 0 has no redundancy built into it. RAID 1 and RAID 10 are
less cost effective then RAID 5 because of the one-to-one copying that is
done, which reduces the number of hard drives available in the RAID array by
half.
Bạn đang xem 1. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P147 POTX