exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 80 discussion

Actual exam question from Microsoft's AZ-305
Question #: 80
Topic #: 4
[All AZ-305 Questions]

HOTSPOT
-

You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements:

• Support 15,000 disk IOPS.
• Support SR-IOV.
• Minimize costs.

What should you include in the solution? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
SomeCert
Highly Voted 1 year, 8 months ago
What's the point of memorizing this kind of sheit?
upvoted 117 times
AdventureChick
1 year, 2 months ago
Microsoft has a minimum WTF?!? threshold required per user per exam (min_WTF) If they don't add crap like this, they don't hit the quota, it generates a crapload of alerts and a dashboard in Redmond turns bright red. :)) Yes .... I've been studying too long and just seeing if anyone is paying attention.
upvoted 25 times
...
exam_taker24
1 year, 6 months ago
I agree, it's dumb
upvoted 6 times
...
betterthanlife
1 year, 7 months ago
It's stupidity...
upvoted 7 times
...
NinjaDog00
1 year, 8 months ago
Agree.....
upvoted 9 times
...
...
[Removed]
Highly Voted 1 year, 10 months ago
Answers are correct: Azure Virtual Machine: Use a high-performance Azure Virtual Machine such as the Dv3 or Ev3 series, which are optimized for workloads that require low latency and high throughput. SR-IOV: Enable SR-IOV on the Virtual Machine. SR-IOV allows for direct communication between the virtual NIC and the physical NIC, reducing latency and increasing throughput. Azure Premium SSD Disks: Use Azure Premium SSD Disks as they are optimized for performance-sensitive workloads and have a high IOPS and throughput limit.
upvoted 12 times
...
SeMo0o0o0o
Most Recent 2 weeks, 6 days ago
CORRECT
upvoted 1 times
...
UWSFish
4 months, 1 week ago
To help you remember its a dumb sh1t question so DS VMs
upvoted 4 times
...
Lazylinux
7 months, 2 weeks ago
Given answer is correct, Here is my take on this and no disrespect to anyone 1- If you got this question right within 60 seconds than i suggest you definitely need to get a life 2- MS asks such questions, i call them landmines!! means if you get it right (trigger the landmine) MS will know for sure you have been reading/accessing braindumbs; so i will happily answer this question wrong even though i was able to guess one part right!!
upvoted 6 times
...
Crossfader2208
9 months ago
I will tattoo this info into my brain. Very important.
upvoted 5 times
...
mtc9
9 months ago
I just love questions like that.
upvoted 2 times
...
dave22339
9 months, 4 weeks ago
Just memorise the answer. It's the one named after a Citroen. Don't have a way of memorising premium yet.
upvoted 3 times
guntor66
9 months ago
Citroen DS could target people in the “Premium” class, with a certain prestige. Citroen DS was at the time a presidential car in France ;)
upvoted 5 times
...
Fidel_104
9 months ago
these are the kind of insights I'm looking for among the comments
upvoted 2 times
...
...
NIC_Name
1 year, 2 months ago
The exam is open book at last, so a search in the Exam for Virtual Machine DS gives the answer.
upvoted 7 times
...
SaiKJ
1 year, 3 months ago
:-).. there is no point in asking such questions in design.
upvoted 4 times
...
hantolini
1 year, 3 months ago
Answer is Correct: NC and NV does not support SR-IOV (Accelerated Networking). Per this note, enable it on this VMs types has no effect. https://learn.microsoft.com/en-us/azure/virtual-network/accelerated-networking-overview?tabs=redhat#supported-vm-instances So, only Ds vms type take advantage of SR-IOV. The, Premium SSD is enougth to support 15000 IOPs
upvoted 3 times
...
Bintokol
1 year, 4 months ago
From olabiba.ai: DS= Dedicated series NC=GPU-optimized NV=Virtualized GPU ....and I agree, Why we need to memorize this!!!!
upvoted 10 times
...
NotMeAnyWay
1 year, 5 months ago
Virtual machine series: The correct option is a. DS. Explanation: The DS series Azure Virtual Machines are designed for applications that require high storage performance and are ideal for SQL Server instances. The DSv3 and Dsv4-series, for instance, support Azure's premium SSDs and offer good I/O throughput, making them suitable for SQL Server workloads. NC and NV series are more oriented towards GPU-intensive and AI workloads, which are not the requirement in this case. SR-IOV is supported by DS series VMs. Disk Type: The correct option is b. Premium SSD. Explanation: To achieve 15,000 IOPS, you would need Premium SSDs. Standard SSDs offer lower performance in terms of IOPS and throughput, and while Ultra Disks could provide the necessary IOPS, they are more expensive and hence not the optimal choice for minimizing costs.
upvoted 7 times
...
lombri
1 year, 7 months ago
The answer seems correct: 1. DS Ideal for testing and development, small to medium databases, and low to medium traffic web servers. D-series, feature a more powerful CPU and optimal CPU-to-memory configuration, making them suitable for most production workloads. 2. Premium SSD Azure Premium SSDs deliver high-performance and low-latency disk support for virtual machines (VMs) with input/output (IO)-intensive workloads.(max IOPS 20,000) For any consultation see look this link is going to be helpful for every one : Link 1 = https://learn.microsoft.com/en-us/azure/virtual-machines/sizes Link 2 = https://learn.microsoft.com/en-us/azure/virtual-machines/dv2-dsv2-series Link 3 = https://learn.microsoft.com/en-us/azure/virtual-machines/sizes-general Link 3 = https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types#disk-type-comparison
upvoted 1 times
...
zellck
1 year, 9 months ago
1. DS 2. Premium SSD https://learn.microsoft.com/en-us/azure/virtual-network/accelerated-networking-overview https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types#disk-type-comparison Premium SSD - Max IOPS: 20,000
upvoted 7 times
...
pkkalra
1 year, 9 months ago
Premium SSD supports upto 20,000 IOPS Only DS supports SR-IOV/Accelerated Networking Although NC and NV sizes will show in the command below, they do not support Accelerated Networking. Enabling Accelerated Networking on NC or NV VMs will have no effect. https://learn.microsoft.com/en-us/azure/virtual-network/accelerated-networking-overview https://learn.microsoft.com/en-us/azure/virtual-network/accelerated-networking-overview
upvoted 3 times
pkkalra
1 year, 9 months ago
https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types
upvoted 1 times
...
...
OPT_001122
1 year, 10 months ago
1. DS 2. Premium SSD
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
Loading ...