YOU ARE DESIGNING A NEW DATABASE SERVER FOR YOUR COMPANY. YOU WISH...

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.