DP-300 Certification Practice Question #131

Question

You have SQL Server on an Azure virtual machine.
You need to add a 4-TB volume that meets the following requirements:
✑ Maximizes IOPs
✑ Uses premium solid state drives (SSDs)
What should you do?

Accepted Answer

To maximize IOPS for a 4-TB storage volume on an Azure VM, the best practice is to stripe multiple smaller disks together (RAID 0 / stripe set). Each Premium SSD in Azure has a capped IOPS limit based on its size (e.g., a 1-TB P30 SSD has 5,000 IOPS, while a 4-TB P50 SSD has 7,500 IOPS). Creating a stripe set with four 1-TB SSDs aggregates their IOPS limits to provide up to 20,000 IOPS, which is significantly higher than using a single 4-TB SSD (7,500 IOPS) or other RAID configurations.

More DP-300 practice questions