DP-300 · Question #210
DP-300 Question #210: Real Exam Question with Answer & Explanation
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
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?
Options
- AYes
- BNo
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.