Microsoft DP-300 Exam - Topic 8 Question 2 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 2
Topic #: 8

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?

D64

Show Suggested Answer

Suggested Answer: D

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 Jamal at May 05, 2022, 09:02 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jesusita

4 months ago

Wait, are we really saying 8 files is the best? That seems low!

upvoted 0 times

...

Deonna

4 months ago

64 files seems excessive, right?

upvoted 0 times

...

Dulce

4 months ago

I thought it was 4 files for optimal performance?

upvoted 0 times

...

Tamra

5 months ago

Actually, it's recommended to have fewer than the number of vCPUs, like 8.

upvoted 0 times

...

Sherell

5 months ago

Tempdb should have one data file per vCPU, so 16 files.

upvoted 0 times

...

Kayleigh

5 months ago

I feel like 8 data files might be a safe bet, but I’m not entirely confident about that.

upvoted 0 times

...

Truman

5 months ago

I practiced a similar question, and I think the recommendation is to have 1 data file per vCPU, but I can't recall the exact number for this case.

upvoted 0 times

...

Zana

5 months ago

I remember something about starting with 4 data files for tempdb, but I'm not sure if that's enough for this setup.

upvoted 0 times

...

Ronny

5 months ago

I think tempdb should have one data file per CPU core, so maybe 16 files since we scaled up to 16 vCPUs?

upvoted 0 times

...

Macy

5 months ago

Okay, let's think this through. We need to send notifications to multiple external systems whenever the status__picklist changes. A Record-Triggered flow could work, but a Platform event might be a better option to decouple the notification logic from the record update.

upvoted 0 times

...

Sherman

5 months ago

Ah, I think I know the answer to this one. The ACK method is part of the INVITE transaction, so there wouldn't be a separate final response to it.

upvoted 0 times

...

Gerry

5 months ago

I was confused about whether "Elastic Bare Metal Cluster" fits into this category as well. I feel like it was mentioned somewhere!

upvoted 0 times

...