Microsoft DP-300 Exam - Topic 1 Question 128 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 128
Topic #: 1

[All DP-300 Questions]

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine

has 4 vCPUs and 28 GB of memory.

You scale up the virtual machine to 8 vCPUSs and 64 GB of memory.

You need to provide the lowest latency for tempdb.

What is the total number of data files that tempdb should contain?

D64

Show Suggested Answer

Suggested Answer: C

The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database

by Pamella at May 01, 2026, 11:35 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Merissa

5 days ago

I'm not entirely sure, but I think I practiced a question like this where the answer was 4 files for a lower number of vCPUs.

upvoted 0 times

...

Sherill

10 days ago

I remember reading that tempdb should have one data file per vCPU for optimal performance, so I think it might be 8 files.

upvoted 0 times

...