Microsoft
DP-300 · Question #211
Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You now have to scale up…
The correct answer is B. No. As per the Microsoft documentation, you should have 1 file per vCore for TempDB with a limit of 8 https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance- guidelines-best-practices
Submitted by rachelw· Mar 6, 2026Monitor, configure, and optimize database resources
Question
Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You now have to scale up the virtual machine to 16 vCPUs and 64 GB of memory. You have to provide the lowest latency for the tempdb database. You decide to create 4 data files for tempdb Would this fulfill the requirement?
Options
- AYes
- BNo
How the community answered
(49 responses)- A41% (20)
- B59% (29)
Explanation
As per the Microsoft documentation, you should have 1 file per vCore for TempDB with a limit of 8 https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance- guidelines-best-practices
Community Discussion
No community discussion yet for this question.