Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 35 discussion

Actual exam question from Microsoft's DP-300

Question #: 35
Topic #: 3

DRAG DROP -
You are building an Azure virtual machine.
You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS.
You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS.
You need to configure storage for the virtual machine to support the database.
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer

Suggested Answer:

Follow these same steps to create striped virtual disk:
✑ Create Log Storage Pool.
✑ Create Virtual Disk
✑ Create Volume

Box 1: a storage pool -
Box 2: a virtual disk that uses stripe layout
Disk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks.

Box 3: a volume -
Reference:
https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/

by QiangQiang at Feb. 4, 2021, 11:11 p.m.

Comments

Submit Cancel

guillermo

Highly Voted 4 years, 4 months ago

Storage Layout options Simple, Mirror Or Partity. Create Virtual Disk with simple layout is correct.

upvoted 21 times

Raffer

4 years, 3 months ago

Correct. Striping would not make sense in this scenario, as there are only 2 disks, and a minimum of 3 disks is required for striping as it uses parity. The only option that makes sense is to use the 2 disks with Simple layout which is, in effect, striping without parity. In this scenario, one has to assume that there is external resiliency, as Simple layout does not protect against disk failure.

upvoted 3 times

Natali

11 months, 1 week ago

Minimum number of disks for striping is 2.

upvoted 1 times

...

gills

4 years, 1 month ago

This stripe is not about creating redundancy like RAID 5. This is about combining the total IOPS of the two virtual disk into a single volume with 10,000 IOPS. Redundancy is already provided by the Azure infrastructure hosting the virtual disk. It runs at 11 9s.

upvoted 7 times

...

shantest1

4 years ago

1.2TB total size is the key, guillermo is correct.

upvoted 2 times

...

remz

4 years, 4 months ago

guillermo is right

upvoted 1 times

...

cusman

3 years, 3 months ago

"Simple" is basically "Stripping without Parity", so in this case that is the better choice. https://support.microsoft.com/en-us/windows/storage-spaces-in-windows-b6c8b540-b8d8-fb8a-e7ab-4a75ba11f9f2

upvoted 1 times

...

Load full discussion...

...

cck21

Highly Voted 4 years, 3 months ago

Answer given is correct. You can stripe 2 premium data disk to get 10000 IOPS. https://techcommunity.microsoft.com/t5/sql-server/optimize-oltp-performance-with-sql-server-on-azure-vm/ba-p/916794

upvoted 14 times

CaptainJameson

3 years, 6 months ago

I think the catch here is simple layout is actually the same as striping. When you create a virtual disk, you specify 'simple', but the technique used to be called striping in windows.

upvoted 1 times

scottytohotty

12 months ago

Simple is not striping…

upvoted 1 times

...

shantest1

4 years ago

How about getting 1.2TB space? that is the key here, so simple layout

upvoted 1 times

...

scottytohotty

Most Recent 1 year ago

Going with the given solution. The simple layout option is very rarely mentioned, but striping is called out in several articles like the below. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql

upvoted 1 times

scottytohotty

1 year ago

Furthermore, a simple volume just acts as another disk. Seems not ideal for this situation. https://learn.microsoft.com/en-us/windows/win32/vds/volume-object

upvoted 1 times

...

KingChuang

2 years, 4 months ago

Given answer is correct. Question request 1.2T and 10,000 IOPS. VM has two P30 SSDs. So, you need use stripe (RAID0). https://learn.microsoft.com/en-us/azure/virtual-machines/premium-storage-performance#disk-striping

upvoted 2 times

...

Ciupaz

2 years, 8 months ago

Provided answer is not correct. Having only 2 disk, better choose the simple layout, not striping.

upvoted 1 times

...

Ciupaz

2 years, 9 months ago

Striping is RAID 0, and to establish a RAID 0 volume, a minimum of at least 2 hard disk drives are required.

upvoted 2 times

...

eric0718

3 years, 2 months ago

The answer is correct

upvoted 2 times

...

Oralinux

3 years, 4 months ago

Provided answer is correct Stripe multiple Azure data disks using Storage Spaces to increase I/O bandwidth up to the target virtual machine's IOPS and throughput limits. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage

upvoted 2 times

...

reachmymind

3 years, 4 months ago

-> a storage pool -> a virtual disk that uses the simple layout -> a volume There are only three layouts while creating virtual disks on a storage pool: Simple - Data is striped across physical disks, maximizing capacity and throughput Mirror - Data is striped across physical disks, creating two or three copies of data Parity - Data and parity information is striped across physical disks, increasing reliability

upvoted 9 times

...

Wsim

4 years, 3 months ago

Minimum 2 disks are needed for Striping, I feel given answerer is correct. "a virtual disk that uses stripe layout" https://docs.microsoft.com/en-us/troubleshoot/windows-server/backup-and-storage/establish-striped-volume-raid-0#:~:text=Disks%3A%20A%20minimum%20of%20two,very%20quickly%20without%20data%20loss.

upvoted 5 times

...

QiangQiang

4 years, 5 months ago

correct

upvoted 3 times

...