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:
Answer: 
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
vm size are previous generations
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sizes
0
0
i would choose data drive premium, transaction log standard (up to 500 iops)
and temp db on local storage ( DS-series VMs have roughly 4,000 IOPS and 33-MB/s throughput per core for cache and local SSD I/Os.)
and the vm size ds3 becasue the other 2 does not support premium storage
0
0