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

Exam DP-201 All Questions

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

Exam DP-201 topic 19 question 1 discussion

Actual exam question from Microsoft's DP-201
Question #: 1
Topic #: 19
[All DP-201 Questions]

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.
Which type of disk should you recommend?

  • A. Standard SSD Managed Disk
  • B. Premium SSD Managed Disk
  • C. Ultra SSD Managed Disk
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
CONT_SQL3 requires an initial scale of 35000 IOPS.
Ultra SSD Managed Disk Offerings

The following table provides a comparison of ultra solid-state-drives (SSD) (preview), premium SSD, standard SSD, and standard hard disk drives (HDD) for managed disks to help you decide what to use.

Reference:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disks-types
by Kampai787 at Dec. 18, 2020, 12:41 a.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
mohowzeh
Highly Voted 4 years, 4 months ago
The answer is correct, but it is interesting to note that data engineers are apparently supposed to know about hard disk selections for a VM.
upvoted 11 times
ZodiaC
3 years, 12 months ago
True it is weird...
upvoted 1 times
...
...
davem0193
Most Recent 3 years, 11 months ago
https://docs.microsoft.com/en-us/azure/virtual-machines/disks-types
upvoted 1 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