DP-300 Question #32: Real Exam Question with Answer & Explanation

Question

You have a failover cluster deployed to Microsoft Azure virtual machines. You plan to deploy a new Microsoft SQL instance to the cluster. The instance will host one database that has 10 file groups. You provision 10 disks for the instance. You need to recommend a storage solution that always provides the fastest possible reads for the database. What should you include in the recommendation?

Options

• Adynamic disks that use striping
• Bone file group per disk
• Ca storage space
• Ddynamic disks that use mirroring

Explanation

To achieve the fastest possible reads for a SQL Server database with multiple file groups across several disks, using dynamic disks configured with striping (RAID 0) is the optimal storage solution.

Common mistakes.

• B. While assigning one file group per disk can provide some parallelism, it does not inherently provide the 'fastest possible reads' without also striping the data across multiple disks to further enhance I/O throughput.
• C. A Storage Space in Windows Server can be configured with various redundancy levels or simple spaces, but 'a storage space' alone doesn't guarantee the fastest reads, as mirrored or parity spaces prioritize data protection over raw speed.
• D. Dynamic disks with mirroring (RAID 1) primarily provide data redundancy and fault tolerance by duplicating data, which can slightly improve read performance but does not offer the same raw speed benefits as striping across multiple disks.

Concept tested. SQL Server storage performance with disk striping

Reference. https://learn.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance#data-disks

No community discussion yet for this question.