When deploying an SAP AnyDB (e.g., SQL Server or Oracle) workload on Azure Virtual Machines, which feature must you enable on the data and log Premium Managed Disks to achieve the best possible read performance?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: Read-only caching

For database data files on Premium Storage, 'Read-only' caching is highly recommended to significantly improve read performance. 'None' is required for log files because they requi...

๐Ÿ“‹Part of Microsoft Certified: Azure for SAP Workloads Specialty (AZ-120) ยท Azure Certification Practice
Real Exam ScenarioAzure Virtual Machines

When deploying an SAP AnyDB (e.g., SQL Server or Oracle) workload on Azure Virtual Machines, which feature must you enable on the data and log Premium Managed Disks to achieve the best possible read performance?

โœ“ Correct Answer & ExplanationAzure Virtual Machines

Correct Answer

Read-only caching

Why This Answer Is Correct

For database data files on Premium Storage, 'Read-only' caching is highly recommended to significantly improve read performance. 'None' is required for log files because they require strict sequential write performance without caching interference.

๐Ÿ“š What This Question Tests

This question evaluates your knowledge of Azure Virtual Machines โ€” a core concept tested in Microsoft Certified: Azure for SAP Workloads Specialty (AZ-120). Understanding Azure Virtual Machines is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.