🔥 3-day streak
Microsoft Azure Database Administrator Associate136 / 144
Question 136 of 144

You are deploying a mission-critical OLTP workload on SQL Server running in an Azure VM. You attach multiple Premium SSD managed disks and use Storage Spaces to build a striped volume for the user database data files (.mdf/.ndf). The workload is heavily read-intensive with a high buffer cache hit ratio and occasional large read scans. You must configure the disk host caching setting for the data-file volume to maximize read performance while remaining supported for a data-file workload. Which host caching setting should you configure?

Reviewed for accuracy · Report an issueNext question