Difficulty: Easy
Correct Answer: RAID 0 (striping)
Explanation:
Introduction / Context:
Disk I/O can bottleneck database-style client–server applications. RAID levels trade performance, capacity, and fault tolerance differently. When the explicit goal is the highest possible performance and no requirement for redundancy is stated, RAID 0 (striping) is the fastest option because it distributes reads and writes across multiple spindles without parity overhead.
Given Data / Assumptions:
Concept / Approach:
RAID 0 splits data into stripes written across disks concurrently, increasing aggregate throughput and IOPS. RAID 1 mirrors data for redundancy but provides at best modest write performance improvements and halves usable capacity. RAID 5 adds parity for fault tolerance but incurs a write penalty (read-modify-write), which slows small random writes common in query workloads.
Step-by-Step Solution:
Verification / Alternative check:
Benchmark before/after with representative queries to confirm lower latency and higher throughput on the striped volume.
Why Other Options Are Wrong:
RAID 1: Prioritizes availability; write performance gains are limited.
RAID 5: Write penalty harms performance under frequent updates.
RAID 2: Obsolete/not implemented in commodity controllers.
None: A clear performance-maximizing choice exists.
Common Pitfalls:
Ignoring that RAID 0 has no fault tolerance—if any disk fails, the volume is lost. Use backups and consider RAID 10 if both speed and redundancy are required.
Final Answer:
RAID 0 (striping)
Discussion & Comments