DP-300 Certification Practice Question #32

Question

You have an Azure subscription.

You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.

You need to configure the disks on the virtual machine. The solution must meet the following requirements:

•	Minimize latency for transaction logs.
•	Minimize the impact on IO throughput of the virtual machine.

Which type of disk should you use for each workload? To answer, drag the appropriate disk types to the correct workloads. Each disk type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Accepted Answer

The question has two distinct requirements: (1) minimize latency for transaction logs — this points to Ultra Disk, which provides the lowest possible I/O latency (sub-millisecond) per MS best-practice guidelines; (2) minimize the impact on VM I/O throughput — TempDB on the local ephemeral SSD (which has its own dedicated I/O path separate from managed disks) achieves exactly this. The community consensus (licna with 12 votes; multiple others) and MS Learn storage guidelines both confirm this mapping.

More DP-300 practice questions