Exam DP-300 topic 3 question 21 discussion

Actual exam question from Microsoft's DP-300

Question #: 21
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 shrink the transaction log file.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by o2091 at Nov. 13, 2021, 12:06 a.m.

Comments

Submit Cancel

CaptainJameson

Highly Voted 1 year, 7 months ago

Selected Answer: B

B is correct, related to tempdb performance, see article from solution

upvoted 5 times

...

raavilam

Most Recent 8 months, 2 weeks ago

B is correct PAGELATCH_UP: An operation is waiting for an update latch on an in-memory page. Update latches are commonly used when there’s row versioning activity in tempdb, or when system allocation pages are being updated https://documentation.red-gate.com/sm4/working-with-overviews/using-performance-diagnostics/list-of-common-wait-types/pagelatch_up

upvoted 1 times

...

o2091

1 year, 9 months ago

Answer looks correct

upvoted 3 times

...