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

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam
Go to Exam

Exam 70-765 topic 3 question 93 discussion

Actual exam question from Microsoft's 70-765
Question #: 93
Topic #: 3
[All 70-765 Questions]

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?

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
Expalantion:
P10 has 500 IOPS per disk, which provides for more than 1 million IOPS per month.
Note: 3600*30* 500 is 54 million IOPS/month.
References: https://azure.microsoft.com/en-us/pricing/details/managed-disks/
by STH at Sept. 8, 2019, 6:52 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
sql14
4 years, 6 months ago
The question also says: Solution must minimize costs. I thought the answer would be - E. Standard geo-redundant disk storage
upvoted 1 times
StillConfused
4 years, 5 months ago
I think even D, locally redundant disk storage. There's no requirement in the question for geo-redundancy and that could be achieved anyway if one of the VMs used in the AG was placed in a different region.
upvoted 1 times
...
...
Slava_bcd81
4 years, 7 months ago
also there is AG, so 1 mln transactions/month will be at least doubled
upvoted 1 times
Slava_bcd81
4 years, 7 months ago
sorry, nevermind that comment, please
upvoted 1 times
...
...
MelKr
4 years, 11 months ago
It gets even cheaper if the databases are stored in "Standard locally redundant blob storage". So G might be right as well.
upvoted 1 times
KC
4 years, 10 months ago
I think that’s not an option, because the question specifies that these are Azure VM that will be used for SQL Server. So locally redundant would not be applicable.
upvoted 1 times
KC
4 years, 10 months ago
Nevermind. I guess I misunderstood the locally redundant option.
upvoted 1 times
...
...
...
STH
5 years, 8 months ago
The answer is good, but not the maths... There is 3600 seconds in an hour and around 30 days in a month, but the formula forgot the 24 hours by day... So there is 3600 * 24 * 30 * 500 that are 1296 millions IO per month
upvoted 2 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