ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 3 question 2 discussion

Actual exam question from Microsoft's DP-300
Question #: 2
Topic #: 3
[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 16 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?

  • A. 2
  • B. 4
  • C. 8
  • D. 64
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by MattyO at July 5, 2020, 8:57 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
MattyO
Highly Voted 3 years, 5 months ago
Answer should be 'C. 8 TempDb Files'
upvoted 38 times
...
gills
Highly Voted 2 years, 6 months ago
Exact same question earlier on listed answer as 64 files. Now same question and answer is 8 . LOL ....
upvoted 7 times
Eleonora77
2 years, 5 months ago
Not the same, read the explanation "If the number of logical processors is greater than eight....". In that case there were 16 vCPUs. Here 8 is not greater than 8
upvoted 4 times
...
gerard
1 year, 11 months ago
theb differnce between this question and the previous question the previous: qustion You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. this question:You scale up the virtual machine to 8 vCPUSs and 64 GB of memory.
upvoted 1 times
...
...
borisariana
Most Recent 10 months, 3 weeks ago
The number of files would be 64 according to the Microsoft documentation. 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.
upvoted 1 times
TheMCT
9 months ago
Where are you getting 64? 64 GB is memory is memory in the question not processors... Answer c, 8 tempDb files is correct.
upvoted 3 times
...
...
Mussie
1 year, 4 months ago
Answer C, Very know 8 to 16. Not greater than vCores.
upvoted 2 times
...
eric0718
1 year, 7 months ago
Selected Answer: C
If the number of logical processors is greater than eight (8), use eight data files. If contention continues, increase the number of data files by multiples of four (4) up to the number of logical processors until the contention is reduced to acceptable levels. Alternatively, make changes to the workload or code. https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation-contention
upvoted 5 times
...
[Removed]
2 years, 6 months ago
based on this article , answer should be 8 https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation-contention
upvoted 1 times
...
Jas_dandiwal
2 years, 9 months ago
64 files as they asked for lowest latency. the situation is not about contention and not for standard setup.
upvoted 1 times
...
Jay_Krish
2 years, 9 months ago
The answer should be C. 8
upvoted 1 times
...
Billhardy
2 years, 10 months ago
correct answer should be 8 here
upvoted 2 times
...
jarihd1
2 years, 10 months ago
64 is the Possibility and since need lowest latency for tempdb so 8 will be good Practice only not the Answer
upvoted 1 times
...
QiangQiang
2 years, 10 months ago
the best solution is to have 16 tempdb files, if the contention still exists, increase the number to 20 , 24 or even 28. but I wouldn't expect to see any difference between 32 and 64 tempdf files in this case.
upvoted 1 times
gills
2 years, 6 months ago
That is not correct. it is multiples of 4 , not additional of 4 as you wrote. So it should be 4 (since there was 4 vCPU initially), 16, 64.
upvoted 2 times
...
...
wvand
2 years, 10 months ago
64 files is a ridiculous amount of data files for tempdb
upvoted 1 times
...
Phund
2 years, 11 months ago
start with 8 files, add multiple of 4 files every time and do not greater than number of logic cores. The answer should be 'C. 8 TempDb Files'
upvoted 1 times
...
BurhanUddin
2 years, 11 months ago
Is C correct answer?
upvoted 1 times
...
chirik
3 years ago
Makes sense to go with 8 and then add number files based on contention. so I would vote for Ans C. Check this article for better explanation https://www.sqlskills.com/blogs/paul/correctly-adding-data-files-tempdb/
upvoted 1 times
...
Dhiva_
3 years ago
Cannot contain more data files than the processor. So the answer would be C,8!
upvoted 1 times
...
MediMedi
3 years, 1 month ago
since contention is not provided as part of question, 8 sounds like the answer.
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel