nerdexam
Microsoft

DP-300 · Question #158

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. You should instead reduce the use of table variables and temporary tables. Or you could create additional tempdb files Note: The following operations use tempdb extensively: Repetitive create-and-drop operation of temporary tables (local or global). Table variables that use…

Submitted by thandi_sa· Mar 6, 2026Optimize query performance

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have SQL Server 2019 on an Azure virtual machine. You are troubleshooting performance issues for a query in a SQL Server instance. To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856. You need to improve system performance. Solution: You change the data file for the master database to autogrow by 10 percent. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(28 responses)
  • A
    21% (6)
  • B
    79% (22)

Explanation

You should instead reduce the use of table variables and temporary tables. Or you could create additional tempdb files Note: The following operations use tempdb extensively: * Repetitive create-and-drop operation of temporary tables (local or global). * Table variables that use tempdb for storage. https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce- allocation-contention

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice