HOTSPOT
You plan to migrate a Microsoft SQL Server workload from an on-premises server to a Microsoft Azure virtual
machine (VM). The current server contains 4 cores with an average CPU workload of 6 percent and a peak
workload of 10 percent when using 2.4Ghz processors.
You gather the following metrics:
You need to design a SQL Server VM to support the migration while minimizing costs.
For each setting, which value should you use? To answer, select the appropriate storage option from each list
in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation:
Data drive: Premium Storage
Transaction log drive: Standard Storage
TempDB drive: Premium StorageNote: A standard disk is expected to handle 500 IOPS or 60MB/s.
A P10 Premium disk is expected to handle 500 IOPS.
A P20 Premium disk is expected to handle 2300 IOPS.
A P30 Premium disk is expected to handle 5000 IOPS.
VM size: A3
Max data disk throughput is 8×500 IOPS
https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-sizes