Provisioning SQL Databases — Question 58

You plan to deploy Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine will have a 30-TB database and will have 10 1-TB VHDs for the database.
You need to configure the storage to meet the following requirements:
✑ Evenly distribute read and write operations across the VHDs.
✑ Minimize the read and write time.
Which storage configuration should you use?

Answer options

• A. a parity storage pool
• B. a simple storage pool
• C. a mirrored storage pool
• D. a striped volume
• E. a RAID-5 volume

Correct answer: D

Explanation

The correct answer is D, a striped volume, as it allows for even distribution of data across multiple VHDs, which enhances both read and write performance. The other options either do not provide the same level of performance optimization (like the simple and mirrored storage pools) or do not evenly distribute operations (like parity and RAID-5, which have overhead for redundancy).