Provisioning SQL Databases — Question 43

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 independent of 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?

Answer options

• 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

Correct answer: A

Explanation

The Premium P10 disk storage is the best option because it provides the required 100 IOPS for the 30 MB database at the lowest cost among the premium options. The Premium P20 and P30 disks offer higher IOPS, which are unnecessary and more expensive for this requirement, while the standard disk options do not guarantee the needed IOPS.