Microsoft
70-473 · Question #97
You have an application named App1 that uses a Microsoft Azure SQL database. Some users report that they receive messages similar to the following error message. "Transaction (Process ID 65) was dedic
Sign in or unlock 70-473 to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.
Monitor and manage an Azure data platform solution
Question
You have an application named App1 that uses a Microsoft Azure SQL database. Some users report that they receive messages similar to the following error message. "Transaction (Process ID 65) was dedicated on locked resources with another process and has been chosen as the deadlock victim. Rerun the transaction." You need to identity the cause of the error. Which view should you query?
Options
- Asys.dm_os_wait_stats
- Bsys.event_log
- Csys.resource_stats
- Dsys.dm_tran_locks
Unlock 70-473 to see the answer
You've previewed enough free 70-473 questions. Unlock 70-473 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure SQL DB troubleshooting#deadlocks#DMV#sys.dm_os_wait_stats