A company requires a storage solution that combines performance and redundancy for a main database...

For a main database server with high read/write activity, the best RAID choice must deliver strong performance while still providing fault tolerance. Per CompTIA A+ Core 1 (220-1201) storage/RAID objectives, RAID 10 (1+0) combines disk mirroring (RAID 1) and disk striping (RAID 0). Striping improves performance by distributing read/write operations across multiple disks, which is ideal for databases that perform frequent transactions. Mirroring provides redundancy by keeping an identical copy of data on a paired drive, allowing the system to tolerate drive failures (typically one drive per mirrored pair) without data loss.

RAID 0 is fast but offers no redundancy, making it inappropriate for critical servers. RAID 5 and RAID 6 use parity, which provides redundancy but introduces a write penalty because parity must be calculated and written during updates—often a poor fit for workloads with heavy random writes like databases. RAID 6 is even more write-intensive