Microsoft
DP-300 · Question #248
Hotspot 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 perform
Sign in or unlock DP-300 to reveal the answer and full explanation for question #248. The question stem and answer options stay visible for context.
Submitted by kim_seoul· Mar 6, 2026Plan and implement data platform resources
Question
Hotspot 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. Answer:
Exhibits
Answer Area
- variables.dataDisks.cachingNoneReadOnlyReadWrite
- caching for log disks (conditional in copy loop)NoneReadOnlyReadWrite
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#disk caching#ARM template#SQL Server VM#I/O performance