Exam DP-300 topic 3 question 31 discussion

I think the correct answer is B), because you should have 8 data files for 8vCPU in total, but you already have some data files and you just need to add/configure extra secondary files

C is the right answer

C is the right answer , please refer JerryChan and Skaeakus91 comments

Answer is: C To reduce tempdb contention without negatively affecting server performance, it is recommended to configure as many secondary data files as there are CPU cores up to a maximum of 8. This can help distribute the workload and reduce contention on tempdb.

Answer should be C

The number of secondary data 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. Then if contention continues, increase the number of data files by multiples of four until the contention decreases to acceptable levels, or make changes to the workload/code. So answer should be C.8

Is the question being asked is total number of tempdb files or additional tempdb files to be configured?

I think the correct answer is B), because you should have 8 data files for 8vCPU in total, but you already have some data files and you just need to add/configure extra secondary files.

There should be one TempDB data file for each thread/core/vCPU on the instance with a maximum of 8.