CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A database administrator is planning the storage for a new transactional database system that requires high IOPS and low latency for small, random read/write operations. Which storage solution would provide the BEST performance for this workload?
- ACloud object storage
- BSolid State Drive (SSD) RAID 10 array
- CNetwork Attached Storage (NAS) with SATA drives
- DHard Disk Drive (HDD) RAID 5 array
Show answer & explanationAnswer & explanation
Correct answer: B. Solid State Drive (SSD) RAID 10 array
SSD RAID 10 arrays offer the highest IOPS and lowest latency due to the inherent speed of SSDs combined with the performance benefits of RAID 10 (striping and mirroring), which is ideal for transactional workloads.
Why the other options are wrong
- A. Cloud object storage is typically optimized for cost and scalability for large, infrequently accessed data, not for high IOPS, low-latency transactional operations.
- C. NAS with SATA drives introduces network latency and uses slower SATA HDDs, which would not meet high IOPS and low latency requirements.
- D. HDDs have significantly lower IOPS and higher latency compared to SSDs, making them unsuitable for high-performance transactional workloads.
Database Storage Tiers
Categorization of storage solutions based on performance, cost, and capacity, to match different database workload requirements.
- High-performance tiers use SSDs for low latency and high IOPS.
- Mid-performance tiers often use HDDs in RAID configurations.
- Low-performance/archive tiers use high-capacity, low-cost storage like object storage.
Memory trick: Speedy Solid States Serve Speedy Systems.