Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You deploy the virtual machine (VM) by using the following settings:
The workload on this instance has a very high tempdb load.
You need to maximize the performance of the tempdb database.
Solution: You use an A8 compute-intensive instance and store the tempdb database in Standard storage.
Does the solution meet the goal?
A . Yes
B . No
Answer: B
Explanation:
For D-series, Dv2-series, and G-series VMs, the temporary drive on these VMs is SSD-based. If your workload makes heavy use of TempDB (such as temporary objects or complex joins), storing TempDB on the D drive could result in higher TempDB throughput and lower TempDB latency.
References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance