Note: This question is part of a series of questions that use the same or similar answer choices. An
answer choice may be correct for more than one question in the series. Each question is independentof the other questions in this series. Information and details provided in a question apply only to that
question.
You have deployed a GS-series virtual machine (VM) in Microsoft Azure. You plan to deploy Microsoft SQL
Server.
You need to deploy a 30 megabyte (MB) database that requires 100 IOPS to be guaranteed while minimizing
costs.
Which storage option should you use?
A.
Premium P10 disk storage
B.
Premium P20 disk storage
C.
Premium P30 disk storage
D.
Standard locally redundant disk storage
E.
Standard geo-redundant disk storage
F.
Standard zone redundant blob storage
G.
Standard locally redundant blob storage
H.
Standard geo-redundant blob storage
Explanation:
Premium Storage Disks Limits
When you provision a disk against a Premium Storage account, how much input/output operations per second
(IOPS) and throughput (bandwidth) it can get depends on the size of the disk. Currently, there are three types
of Premium Storage disks: P10, P20, and P30. Each one has specific limits for IOPS and throughput as
specified in the following table:
https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage
Why is Premium Storage required? Standard storage also offers up to 500 IOPS now.
0
0
caspar is right
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/standard-storage
Standard Disks Limits
Unlike Premium Disks, the input/output operations per second (IOPS) and throughput (bandwidth) of Standard Disks are not provisioned. The performance of standard disks varies with the VM size to which the disk is attached, not to the size of the disk. You could expect to achieve up to the performance limit listed in the table below.
Standard disks limits (managed and unmanaged)
VM Tier Basic Tier VM Standard Tier VM
Max Disk size 4095 GB 4095 GB
Max 8 KB IOPS per disk Up to 300 Up to 500
Max Bandwidth per disk Up to 60 MB/s Up to 60 MB/s
0
0
Not sure standard gives the guarantee though.
“requires 100 IOPS to be guaranteed”
0
0
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/standard-storage
Unlike Premium Disks, the input/output operations per second (IOPS) and throughput (bandwidth) of Standard Disks are not provisioned. The performance of standard disks varies with the VM size to which the disk is attached, not to the size of the disk.
You could expect to achieve up to the performance limit listed in the table below.
Standard disks limits (managed and unmanaged)
Max 8 KB IOPS per disk
we must assure 100 IOPS , and with MSSQL our blocksize should be 64KB as best practise.(oltp workload)
so for our blocksize the iops are 500/8=62.5 (because 64/8=8)
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/premium-storage
When you provision a premium storage disk, unlike standard storage, you are guaranteed the capacity, IOPS, and throughput of that disk
so the answer, in my opinion should be A. Premium P10 disk storage
1
0
also P10 has 500 iops..by the way i trust the right answer P10 because of the “guarantee” requirement
1
0