Microsoft
AZ-204 · Question #41
You have implemented code that uses elastic transactions spanning across three different Azure SQL Database logical servers. Database administration report that some transactions take longer to comple
Sign in or unlock AZ-204 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Submitted by femi9· Mar 30, 2026Monitor, troubleshoot, and optimize Azure solutions
Question
You have implemented code that uses elastic transactions spanning across three different Azure SQL Database logical servers. Database administration report that some transactions take longer to complete than expected. You need to use the correct tool to monitor all the transactions originating from the elastic transaction implementation. Which tool should you use?
Options
- AUse the dependencies section of Azure Applications Insights.
- BRun the sys.dm_tran_active_transactions dynamic management view.
- CRun the sys.dm_tran_current_snapshot dynamic management view.
- DRun the sys.dm_tran_active_snapshot_database_transactions dynamic management view.
Unlock AZ-204 to see the answer
You've previewed enough free AZ-204 questions. Unlock AZ-204 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
#elastic transactions#Azure SQL Database#DMV#transaction monitoring