A city engineering CAD database on EC2 needs consistent low-latency IOPS for its data disks. Which EBS guidance is most appropriate?
Select an answer to reveal the explanation.
Short Explanation
CAD databases hate waiting in line—provisioned IOPS SSD is the express lane with reserved tickets. Throughput HDD is for big sequential streams, not twitchy random reads. Pick the volume for the I/O pattern.
Full Explanation
Latency-sensitive database disks typically need SSD volume types with provisioned IOPS (io2/io1) so performance is consistent under load. Throughput HDD (st1) and cold HDD (sc1) target sequential throughput, not low-latency random transactional I/O. Instance store can be fast but is ephemeral and unsuitable as the sole durable CAD database store. Match EBS type to IOPS and latency requirements.