What should you do?

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?
A . Attach two mirrored 4-TB SSDs.
B. Attach a stripe set that contains four 1-TB SSDs.
C. Attach a RAID-5 array that contains five 1-TB SSDs.
D. Attach a single 4-TB SSD.

View Answer

Answer: B

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?tabs=windows2016