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?

The correct answer is B. Attach a stripe set that contains four 1-TB SSDs.. For more throughput, you can add additional data disks and use disk striping. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage- configuration?tabs=windows2016

Submitted by naveen.iyer· Mar 6, 2026Plan and implement data platform resources

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?

Options

AAttach two mirrored 4-TB SSDs.
BAttach a stripe set that contains four 1-TB SSDs.
CAttach a RAID-5 array that contains five 1-TB SSDs.
DAttach a single 4-TB SSD.

How the community answered

(38 responses)

A
5% (2)
B
79% (30)
C
3% (1)
D
13% (5)

Explanation

For more throughput, you can add additional data disks and use disk striping. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage- configuration?tabs=windows2016

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice