HOTSPOT
You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual
machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is
expected to be over 200 gigabytes (GB). You must maximize performance for the database files and the log
file.
You add the following additional drive volumes to the VM:
You have the following requirements:
Maximize performance of the SQL Server instance.
Use Premium storage when possible.
You need to deploy the SQL instance.
In the table below, identify the drive where you must store each SQL Server file type.
NOTE: Make only one selection in each column. Each correct selection is worth one point.
Hot Area:
Explanation:
Enable read caching on the disk(s) hosting the data files and TempDB.
Do not enable caching on disk(s) hosting the log file. Host caching is not used for log files.
Incorrect Answers:
C, D: Avoid using operating system or temporary disks for database storage or logging.
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windowssql-performance