DRAG DROP - You are designing a virtual machine that will run Microsoft SQL Server and contain two data disks. The first data disk will store log files, and the...
Microsoft AZ-305 Exam
Questions Number: 175 out of 268 Questions
65.30%
Question 175
DRAG DROP - You are designing a virtual machine that will run Microsoft SQL Server and 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 host caching method for each disk. The method must provide the best overall performance for the virtual machine while preserving the integrity of the SQL data and logs. Which host caching method should you recommend for each disk? To answer, drag the appropriate methods to the correct disks. Each method 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. Select and Place:
Box 1: None - No data disk caching for the Log files. Box 2: ReadOnly - Guidelines to optimize performance for your SQL Server on Azure Virtual Machines (VMs) include: Set host caching to read-only for data file disks. Set host caching to none for log file disks. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage