nerdexam
Microsoft

DP-300 · Question #209

Your company has an on-premises instance of Microsoft SQL Server. This instance contains a database that has a 5 TiB data file. The database requires 10,000 IOPS. You have to port the database onto…

The correct answer is A. Create a virtual disk that uses the stripe layout C. Create a volume D. Create a storage pool. First, you need to create a storage pool. This can be used to host multiple disks together. Now create a virtual disk based on the stripe Then create a volume from the virtual disk. Option B is incorrect because it is normally used to mirror data from one disk onto another…

Submitted by mike_84· Mar 6, 2026Plan and implement data platform resources

Question

Your company has an on-premises instance of Microsoft SQL Server. This instance contains a database that has a 5 TiB data file. The database requires 10,000 IOPS. You have to port the database onto Azure. You create a virtual machine. You then allocate two 1 TiB, P30 Premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You have to ensure the storage is configured to support the migrated database. Which of the following would you implement for this requirement? (Choose 3 answers)

Options

  • ACreate a virtual disk that uses the stripe layout
  • BCreate a virtual disk that uses mirror layout
  • CCreate a volume
  • DCreate a storage pool

How the community answered

(40 responses)
  • A
    85% (34)
  • B
    15% (6)

Explanation

First, you need to create a storage pool. This can be used to host multiple disks together. Now create a virtual disk based on the stripe Then create a volume from the virtual disk. Option B is incorrect because it is normally used to mirror data from one disk onto another. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance- guidelines-best-practices

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice