Exam DP-300 topic 3 question 23 discussion

Actual exam question from Microsoft's DP-300

Question #: 23
Topic #: 3

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 reduce the use of table variables and temporary tables.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
The following operations use tempdb extensively:
* Repetitive create-and-drop operation of temporary tables (local or global).
* Table variables that use tempdb for storage.
* Etc.
Reference:
https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation-contention

by ss1516 at Nov. 5, 2021, 11:23 a.m.

Comments

Submit Cancel

ss1516

Highly Voted 1 year, 6 months ago

Answer A is correct, other questions in the series have answer B - No. The case is about tempdb problem. https://docs.microsoft.com/en-us/troubleshoot/sql/performance/recommendations-reduce-allocation-contention

upvoted 7 times

...

Ciupaz

Most Recent 6 months, 4 weeks ago

Is for TempDb contention, and in this scenario is better reduce use of table variables and temporary tables.

upvoted 4 times

...

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 23 discussion

Comments

ss1516

Ciupaz

SY0-701