ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam
Go to Exam

Exam AZ-301 topic 3 question 5 discussion

Actual exam question from Microsoft's AZ-301
Question #: 5
Topic #: 3
[All AZ-301 Questions]

DRAG DROP -
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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance
by onlyfunmails at Jan. 3, 2020, 12:30 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
nieuw
Highly Voted 5 years, 1 month ago
As an example, you can apply these guidelines to SQL Server running on Premium Storage by doing the following, Configure "ReadOnly" cache on premium storage disks hosting data files. a. The fast reads from cache lower the SQL Server query time since data pages are retrieved much faster from the cache compared to directly from the data disks. b. Serving reads from cache, means there is additional Throughput available from premium data disks. SQL Server can use this additional Throughput towards retrieving more data pages and other operations like backup/restore, batch loads, and index rebuilds. Configure "None" cache on premium storage disks hosting the log files. a. Log files have primarily write-heavy operations. Therefore, they do not benefit from the ReadOnly cache. https://docs.microsoft.com/en-us/azure/virtual-machines/windows/premium-storage-performance#disk-caching
upvoted 13 times
...
Rajuuu
Highly Voted 5 years, 1 month ago
Caching is for Data only and not for Log files.
upvoted 9 times
AJ_Galosmo
4 years, 10 months ago
This is correct.
upvoted 1 times
...
...
glam
Most Recent 4 years, 4 months ago
Log - None Data - Read only
upvoted 2 times
...
sanketshah
4 years, 5 months ago
given answer is correct.
upvoted 1 times
...
Neetiniti
4 years, 11 months ago
Box1-Log-None-Configure "None" cache on premium storage disks hosting the log files. Log files have primarily write-heavy operations. Therefore, they do not benefit from the ReadOnly cache. Box2-Read Only-Configure "ReadOnly" cache on premium storage disks hosting data files. https://docs.microsoft.com/en-us/azure/virtual-machines/windows/premium-storage-performance#disk-caching
upvoted 1 times
...
pandeya442
5 years, 1 month ago
given ans is correct
upvoted 2 times
...
onlyfunmails
5 years, 5 months ago
Read only Cache for Data disk recommend only for Premium, as Q has P40, its valid. https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance#disks-guidance
upvoted 5 times
tartar
4 years, 9 months ago
Log - None Data - Read only
upvoted 4 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel