Discuss Microsoft DP-300 Exam Topic 8 Question 2

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

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

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Jesusita 12 months ago

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

Deonna 1 year ago

64 files seems excessive, right?

Dulce 1 year ago

I thought it was 4 files for optimal performance?

Tamra 1 year ago

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

Sherell 1 year ago

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

Kayleigh 1 year ago

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

Truman 1 year 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.

Zana 1 year ago

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

Ronny 1 year ago

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

Macy 1 year 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.

Sherman 1 year 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.

Gerry 1 year ago

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

Microsoft DP-300 Exam - Topic 8 Question 2 Discussion