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 6 discussion

Actual exam question from Microsoft's DP-300
Question #: 6
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 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?

  • A. 2
  • B. 4
  • C. 8
  • D. 64
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by anurag1p at March 13, 2021, 7:29 a.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
learnazureportal
Highly Voted 3 years, 10 months ago
16 vCPUs = 8 CPUs = 8 Tempdb data files.
upvoted 18 times
...
Mend
Highly Voted 3 years, 11 months ago
In my view, we need to focus on last sentence - "What is the total number of data files that tempdb should contain?" While 8 is best practice, we can reach up to 64 (in this scenario) during the course of minimizing contention. So answer is 64.
upvoted 9 times
Mend
3 years, 11 months ago
Please ignore my above comment, confused with RAM. I go with 8.
upvoted 7 times
...
...
Vitos25
Most Recent 8 months, 3 weeks ago
Selected Answer: C
C: 8 Temp data files
upvoted 1 times
...
VikJo1978
1 year, 7 months ago
Selected Answer: C
When scaling tempdb in SQL Server, it's recommended to have a number of data files equal to or less than the number of CPU cores, but not exceeding 8 files. In your scenario, after scaling to 8 vCPUs, it would be appropriate to have 8 data files for tempdb. Answer: C. 8
upvoted 2 times
...
Chunchi
3 years, 1 month ago
Selected Answer: C
8 tempdb files is correct answer
upvoted 2 times
...
cusman
3 years, 2 months ago
Selected Answer: C
General rule: When < 8 CPU, use same number of tempdb files as CPU When >=8 CPU, use 8 tempdb files (as first step) Go higher than 8 tempdb files in multiples of 4 only if contention persists
upvoted 4 times
...
Soiram
3 years, 4 months ago
Selected Answer: C
More than 8 vCPUs -> 8 files for TemDB
upvoted 3 times
...
jddc
3 years, 6 months ago
Selected Answer: C
>=8 to <32 = No. of Cores/2 >=32 = No. of Cores/4 So here answer is 8
upvoted 6 times
...
TheSwedishGuy
3 years, 7 months ago
The answer D. 64 is correct. You have 16 vCPUS. You cannot divide 8 files by 16 CPUs and get a full number. Are you going to have 0.5 tempdb-files per CPU? No, you should not. 64 files divided by 16vCPUS means 4 tempDB files per vCPU. Keep a 1:1 ratio between CPUs and tempdb files up to 8. Thereafter, add files if you continue to see allocation contention or if you’re looking to push the I/O subsystem harder.
upvoted 2 times
...
hdenryardila105t00
3 years, 10 months ago
64 Gb is the memory no the number of cpus, Cpus is 16 which number of datafiles should be 8.
upvoted 4 times
...
[Removed]
4 years ago
Based on this article , the answer should be 8 https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation-contention
upvoted 5 times
...
Burrielito
4 years ago
The correct answer should be C...
upvoted 4 times
...
gills
4 years ago
It is multiplication of 4. There was 4 first and then 16 and then 64.
upvoted 1 times
...
YJC
4 years, 2 months ago
According to MOC , it should be 8 as upper.
upvoted 1 times
...
Jas_dandiwal
4 years, 2 months ago
basically they said it was 4 and then they increased to 16, so following best practice first time when cpu increased, DBA will set 8tempdb files. if there is contention after then more files will be added. so this question refers to the first step after cpu increased. tricky
upvoted 2 times
gills
4 years ago
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.
upvoted 3 times
...
...
Starshow
4 years, 2 months ago
i think that the correct answer is 8....
upvoted 1 times
...
anurag1p
4 years, 2 months ago
should be 8
upvoted 4 times
...
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