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

Exam AZ-304 All Questions

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

Exam AZ-304 topic 3 question 8 discussion

Actual exam question from Microsoft's AZ-304
Question #: 8
Topic #: 3
[All AZ-304 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 while preserving integrity of the SQL data and logs.
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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance
by M4gnet1k at Dec. 1, 2020, 4:26 a.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
M4gnet1k
Highly Voted 4 years, 5 months ago
The answers provided are correct, here is the explanation and supporting websites: Log: None—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 Data: readonly—If you have separate storage pools for the log and data files, enable read caching only on the storage pool for the data files. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices
upvoted 97 times
syu31svc
3 years, 7 months ago
Good find there!
upvoted 4 times
...
AubinBakana
2 years, 8 months ago
Thank you
upvoted 1 times
...
...
glam
Highly Voted 4 years, 3 months ago
Log: None— Data: readonly—
upvoted 7 times
...
ranjitklive
Most Recent 3 years, 1 month ago
Set host caching to read-only for data file disks. Set host caching to none for log file disks.
upvoted 2 times
...
Droz36
3 years, 4 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage Correct
upvoted 1 times
...
azurecert2021
4 years, 2 months ago
correct.
upvoted 4 times
...
kopper2019
4 years, 4 months ago
correct - Use premium SSDs for the best price/performance advantages. Configure Read only cache for data files and no cache for the log file.
upvoted 4 times
...
JustDiscussing
4 years, 4 months ago
Following are the recommended disk cache settings for data disks, TABLE 9 Disk caching setting recommendation on when to use this setting None Configure host-cache as None for write-only and write-heavy disks. ReadOnly Configure host-cache as ReadOnly for read-only and read-write disks. ReadWrite Configure host-cache as ReadWrite only if your application properly handles writing cached data to persistent disks when needed. https://docs.microsoft.com/en-us/azure/virtual-machines/premium-storage-performance#disk-caching
upvoted 3 times
...
xAlx
4 years, 5 months ago
Correct https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices#disks-guidance If you are using separate disks for data and log files, enable read caching on the data disks hosting your data files and TempDB data files. This can result in a significant performance benefit. Do not enable caching on the disk holding the log file as this causes a minor decrease in performance.
upvoted 3 times
yyuryyucicuryyforme
3 years, 3 months ago
Indeed https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage#data-file-caching-policies ata 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 will yield the total possible performance available from the virtual machine within the VMs limits, but actual performance will vary 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.
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago