Provisioning SQL Databases — Question 65

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 several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in an Always On Availability Group.
You expect to have less than 1 million IO transaction per month.
You need to recommend a storage solution for the SQL Servers. The solution must minimize 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 correct choice is Premium P10 disk storage, as it provides the necessary performance for SQL Server while keeping costs low for the expected transaction volume. The other premium options (P20 and P30) offer higher performance than needed, while standard options may not meet the performance requirements for SQL Server in an Always On Availability Group.