For each setting, which value should you use?

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.

View Answer

Answer:

Explanation:

Data drive: Premium Storage

Transaction log drive: Standard Storage

TempDB drive: Premium Storage

Note: 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

References: https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-sizes