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 vCPU
Sign in or unlock DP-300 to reveal the answer and full explanation for question #210. The question stem and answer options stay visible for context.
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
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.