AZ-305 Question 159

Question

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.

Accepted Answer

Hotspot Solution:
### Recommended Community Solution:
Data disk: Enable Read-only caching for the disks hosting SQL Server data files. Reads from cache will be faster than the uncached reads from the data disk. Uncached IOPS and throughput plus Cached IOPS and throughput yield the total possible performance available from the virtual machine within the VMs limits, but actual performance varies based on the workload's ability to use the cache (cache hit ratio). Transaction log disk: Set the caching policy to None for disks hosting the transaction log. There is no performance benefit to enabling caching for the Transaction log disk, and in fact having either Read-only or Read/Write caching enabled on the log drive can degrade performance of the writes against the drive and decrease the amount of cache available for reads on the data drive.

AZ-305 Question 159

Explanation

Recommended Community Solution:

Community Discussion

Preparing Practice Exam…

AZ-305 Question 159

Explanation

Recommended Community Solution:

Community Discussion