Examice

Exam DP-300 All QuestionsBrowse all questions from this exam

Question 149

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:

Correct 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/

Discussion

guillermo

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

remz

guillermo is right

Raffer

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.

gills

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.

shantest1

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

cusman

"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

cck21

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

shantest1

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

CaptainJameson

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.

scottytohotty

Simple is not striping…

reachmymind

-> 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

Wsim

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.

QiangQiang

correct

KingChuang

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

Ciupaz

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

eric0718

The answer is correct

Oralinux

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

scottytohotty

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

scottytohotty

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

Ciupaz

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