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

Exam AZ-305 All Questions

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

Exam AZ-305 topic 4 question 48 discussion

Actual exam question from Microsoft's AZ-305
Question #: 48
Topic #: 4
[All AZ-305 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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
by Neo2c at Sept. 6, 2022, 4:57 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
Davin0406
Highly Voted 2 years, 6 months ago
None and ReadOnly. appeared in exam, 10/14/2022. I passed with 946/1000 and there were only 1~2 new questions but others were all from AZ-305 dump.
upvoted 46 times
dimsok
2 years, 3 months ago
This question is in the contribution area so we bought it already, no need for spam.
upvoted 27 times
...
...
zellck
Highly Voted 2 years, 1 month ago
Log: None Data: ReadOnly https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql#data-file-caching-policies Your storage caching policy varies depending on the type of SQL Server data files that are hosted on the drive. The following table provides a summary of the recommended caching policies based on the type of SQL Server data: - 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 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).
upvoted 20 times
zellck
2 years, 1 month ago
-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 9 times
...
...
[Removed]
Most Recent 5 months, 2 weeks ago
CORRECT
upvoted 2 times
...
Lazylinux
1 year ago
Given answer is correct as per https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql#data-file-caching-policies
upvoted 1 times
...
varinder82
1 year, 1 month ago
Final Answer: Log: None Data: ReadOnly
upvoted 2 times
...
eduardobbs
1 year, 1 month ago
Got this on my exam on 06/03/2024
upvoted 2 times
...
JimmyYop
1 year, 3 months ago
appeared in Exam 01/2024
upvoted 3 times
...
NotMeAnyWay
1 year, 9 months ago
Log: None Data: Readonly For SQL Server workloads, Microsoft recommends setting the host caching policy to None for disks hosting log files to preserve data integrity. For data files, the ReadOnly setting is recommended because SQL Server itself handles a significant portion of the data caching. This setting can help with read operations while not impacting the integrity of the data.
upvoted 7 times
...
Tr619899
1 year, 11 months ago
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.
upvoted 3 times
...
OPT_001122
2 years, 2 months ago
Log - none Data - Read Only
upvoted 4 times
...
leoletopic
2 years, 4 months ago
Data file caching policies https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql#data-file-caching-policies
upvoted 4 times
...
ExamTopicsTST
2 years, 5 months ago
Set host caching to read-only for data file disks. Set host caching to none for log file disks.
upvoted 1 times
...
Velidot100
2 years, 7 months ago
Got this on my exam - 12. September 2022
upvoted 8 times
...
Balaji_c_s
2 years, 7 months ago
Answer is right https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql#checklist
upvoted 5 times
pkkalra
2 years, 5 months ago
relevant section from above link https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql#data-file-caching-policies
upvoted 2 times
...
...
Neo2c
2 years, 7 months ago
The Given answer is correct
upvoted 3 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