Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Microsoft
  4. Microsoft Certified: Azure Database Administrator Associate
  5. DP-300 Discussions
  6. DP-300 Exam Topic 3 Question 26 Discussion
 Microsoft Discussions
Exam DP-300 All Questions
Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Go to Exam

Microsoft Certified: Azure Database Administrator Associate DP-300 Question # 26 Topic 3 Discussion

DP-300 Exam Topic 3 Question 26 Discussion:
Question #: 26
Topic #: 3

You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.

Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.

You need to reduce tempdb contention without regatively affecting server performance.

What is the number of secondary data files that you should configure for tempdb?
A.

2

B.

4

C.

8

D.

64

Get Premium DP-300 Questions
Actual exam question for Microsoft DP-300 exam by Sable85458 at May 8, 2026, 6:28:00 PM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit