Home » Microsoft » 70-765 » Does this meet the goal?
Settings Value
VM size D3
Storage Location Drive E
Storage type Standard Tempdb location Drive C
The workload on this instance has of the tembdb load.
You need to maximize the performance of the tempdb database.
Solution: You use a GS- Series VM and store the tempdb database on attached Premium storage.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
Explanation/Reference:
Explanation:
For VMs that support Premium Storage (DS-series, DSv2-series, and GS-series), we recommend storing TempDB on a disk that supports Premium Storage with read caching enabled. There is one exception to this recommendation; if your
TempDB usage is write-intensive, you can achieve higher performance by storing TempDB on the local D drive, which is also SSD-based on these machine sizes.
References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance