DP-300 Certification Practice Question #141

Question

You need to use an Azure Resource Manager (ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files.

How should you complete the template? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

MS Learn best practices for SQL Server on Azure VMs specify: set disk caching to **ReadOnly** for data disks (SQL Server reads data pages frequently but writes are less frequent; ReadOnly cache accelerates reads) and **None** for log disks (transaction log writes are sequential and write-heavy; caching can interfere and reduce performance). Reading the ARM template IF expression: if the disk index is ≥ dataDiskCount it is the log disk and gets the value from dropdown 2 (→ **None**); otherwise it is a data disk and gets `variables('dataDisks').caching` from dropdown 1 (→ **ReadOnly**).

More DP-300 practice questions