Microsoft
DP-300 · Question #210
settings set for the database for automatic tuning. 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…
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 chiamaka_o· Mar 6, 2026Monitor, configure, and optimize database resources
Question
settings set for the database for automatic tuning. 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 2 data files for tempdb Would this fulfill the requirement?
Exhibits
Options
- AYes
- BNo
How the community answered
(51 responses)- A49% (25)
- B51% (26)
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.