DP-300 · Question #32
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…
The correct answer is A. dynamic disks that use striping. 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.
Question
Options
- Adynamic disks that use striping
- Bone file group per disk
- Ca storage space
- Ddynamic disks that use mirroring
How the community answered
(53 responses)- A57% (30)
- B6% (3)
- C26% (14)
- D11% (6)
Why each option
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.
Dynamic disks configured with striping (RAID 0) distribute data across multiple physical disks, allowing for parallel I/O operations. This significantly increases read performance by enabling concurrent access to data spread across the underlying disks, which is ideal for high-performance database workloads like SQL Server requiring fast reads across multiple file groups.
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.
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.
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
Source: https://learn.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance#data-disks
Community Discussion
No community discussion yet for this question.