ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 3 question 35 discussion

Actual exam question from Microsoft's DP-300
Question #: 35
Topic #: 3
[All DP-300 Questions]

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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
guillermo
Highly Voted 4 years, 2 months ago
Storage Layout options Simple, Mirror Or Partity. Create Virtual Disk with simple layout is correct.
upvoted 21 times
Raffer
4 years, 1 month 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
9 months, 1 week ago
Minimum number of disks for striping is 2.
upvoted 1 times
...
gills
3 years, 11 months 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
3 years, 10 months ago
1.2TB total size is the key, guillermo is correct.
upvoted 2 times
...
remz
4 years, 2 months ago
guillermo is right
upvoted 1 times
...
cusman
3 years, 1 month 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 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 13 times
CaptainJameson
3 years, 4 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
9 months, 4 weeks ago
Simple is not striping…
upvoted 1 times
...
...
shantest1
3 years, 10 months ago
How about getting 1.2TB space? that is the key here, so simple layout
upvoted 1 times
...
...
scottytohotty
Most Recent 10 months 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
10 months 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, 2 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, 6 months ago
Provided answer is not correct. Having only 2 disk, better choose the simple layout, not striping.
upvoted 1 times
...
Ciupaz
2 years, 6 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 ago
The answer is correct
upvoted 2 times
...
Oralinux
3 years, 1 month 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, 1 month 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 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, 2 months ago
correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago