Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 6 discussion

Actual exam question from Microsoft's DP-300

Question #: 6
Topic #: 3

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

Suggested Answer: C 🗳️

by anurag1p at March 13, 2021, 7:29 a.m.

Comments

Submit Cancel

learnazureportal

Highly Voted 4 years ago

16 vCPUs = 8 CPUs = 8 Tempdb data files.

upvoted 18 times

...

Mend

Highly Voted 4 years, 1 month 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

4 years, 1 month ago

Please ignore my above comment, confused with RAM. I go with 8.

upvoted 7 times

...

Vitos25

Most Recent 10 months, 3 weeks ago

Selected Answer: C

C: 8 Temp data files

upvoted 1 times

...

VikJo1978

1 year, 9 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, 3 months ago

Selected Answer: C

8 tempdb files is correct answer

upvoted 2 times

...

cusman

3 years, 4 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, 6 months ago

Selected Answer: C

More than 8 vCPUs -> 8 files for TemDB

upvoted 3 times

...

jddc

3 years, 8 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, 9 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

4 years ago

64 Gb is the memory no the number of cpus, Cpus is 16 which number of datafiles should be 8.

upvoted 4 times

...

Burrielito

4 years, 2 months ago

The correct answer should be C...

upvoted 4 times

...

gills

4 years, 2 months ago

It is multiplication of 4. There was 4 first and then 16 and then 64.

upvoted 1 times

...

YJC

4 years, 4 months ago

According to MOC , it should be 8 as upper.

upvoted 1 times

...

Jas_dandiwal

4 years, 4 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, 2 months 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, 4 months ago

i think that the correct answer is 8....

upvoted 1 times

...

anurag1p

4 years, 5 months ago

should be 8

upvoted 4 times

...