You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Suggested Answer:CF🗳️
SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries. Seeing a Count of All Active SQL Server Wait Types. Sometimes we're trying to diagnose a problem and we want to know if we're seeing a large number of wait types occurring. We can do this using sys.dm_exec_requests because the current wait type being experienced is presented. Therefore, if we filter out any background or sleeping tasks, we can get a picture of what the waits are for active requests and we can also see if we have a problem. Here's the query: SELECT COALESCE(wait_type, 'None') AS wait_type, COUNT(*) AS Total
FROM sys.dm_exec_requests - WHERE NOT status IN ('Background', 'Sleeping')
GROUP BY wait_type - ORDER BY Total DESC; Here is an example of the query output: We see that we have two LCK_M_S wait types. This is the wait type we get when we have requests waiting on obtaining a shared lock. We can then query along with sys.dm_tran_locks to determine what types of locks these active requests were trying to obtain: SELECT L.request_session_id, L.resource_type, L.resource_subtype, L.request_mode, L.request_type
FROM sys.dm_tran_locks AS L - JOIN sys.dm_exec_requests AS DER ON L.request_session_id = DER.session_id WHERE DER.wait_type = 'LCK_M_S'; Incorrect: Not A: Azure SQL database does not have sys.dm_pdw_nodes_tran_locks. Not E: Azure SQL database does not have sys.dm_pdw_nodes_os_wait_stats. Reference: https://www.mssqltips.com/sqlservertip/5521/understanding-and-using-sql-server-sysdmexecrequests/
Damn - made it to the last question ... now comes the revising. I've marked on my copy which questions are not for DP-300 (the DP-203 ones). Good Luck everyone!
Hey folks, I sat the exam last week and passed well above 800. I did not have any simulations in mine. Be sure to research the suggested answers and discussions yourself, this way you are learning the necessary areas because the multiple choice ordering will be different in the exam.
I would say around 85% of the questions were in this dump. It's alot to go through 300+ questions but I feel happy I did since many of the questions came up.
Also ExamTopics was the first to update the dump with new questions from the April 2024 updates - the case study for Adatum (financial company) came up in exam.
Thanks ExamTopics and thanks to the community for their comments!
sys.dm_exec_requests: returns information about each request that is executing in SQL Server.
sys.dm_tran_locks: Returns information about currently active lock manager resources in SQL Server. Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted.
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql?view=sql-server-ver16
Returns information about currently active lock manager resources in SQL Server. Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted.
Rest here travesera. You've seen too many DataBases todas.
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Dalamain
Highly Voted 7 months agoDalamain
6 months, 1 week agoigorclapa
Most Recent 1 year, 2 months agovcloudpmp
1 year, 4 months agovcloudpmp
1 year, 4 months agojtu363
1 year, 10 months agoOBIJUAN88
1 year, 6 months ago