nerdexam
MicrosoftMicrosoft

AZ-305 · Question #210

AZ-305 Question #210: Real Exam Question with Answer & Explanation

Sign in or unlock AZ-305 to reveal the answer and full explanation for question #210. The question stem and answer options stay visible for context.

Submitted by packet_pusher· Mar 6, 2026Design and implement storage for Azure compute workloads, specifically optimizing disk caching policies for SQL Server virtual machines to meet performance and reliability requirements.

Question

Drag and Drop Question You are designing a virtual machine that will run Microsoft SQL Server and will contain two data disks. The first data disk will store log files, and the second data disk will store data. Both disks are P40 managed disks. You need to recommend a caching policy for each disk. The policy must provide the best overall performance for the virtual machine. Which caching policy should you recommend for each disk? To answer, drag the appropriate policies to the correct disks. Each policy may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Unlock AZ-305 to see the answer

You've previewed enough free AZ-305 questions. Unlock AZ-305 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

#Azure Managed Disks#SQL Server on Azure VMs#Disk Caching Policies#Azure Storage Performance
Full AZ-305 PracticeBrowse All AZ-305 Questions