You have a SQL pool in Azure Synapse. You discover that some queries fail or take a long time to complete. You need to monitor for transactions that have rolled back. Which dynamic management view should you query?
Correct Answer!
A. sys.dm_pdw_request_steps:
Provides detailed information about each step of a request executed in Azure Synapse Analytics, including execution status and step type.
B. sys.dm_pdw_nodes_tran_database_transactions:
Displays information about active transactions on each node in the distributed database system within Azure Synapse Analytics.
C. sys.dm_pdw_waits:
Shows information about the waiting tasks in Azure Synapse Analytics, including wait types and durations, to help diagnose query performance issues.
D. sys.dm_pdw_exec_sessions:
Lists all active and historic sessions in Azure Synapse Analytics, including session details and activity status.
ChatGPT 4o
Explanation:
sys.dm_pdw_nodes_tran_database_transactions: This view contains information about transactions at the database level, including their state. You can use this view to identify transactions that have been rolled back.
Other Options:
sys.dm_pdw_request_steps: Provides details about the steps for each request, useful for understanding the execution plan of queries but not specific to transactions.
sys.dm_pdw_waits: Contains information about waiting requests, which can help diagnose performance issues but does not specifically track rolled-back transactions.
sys.dm_pdw_exec_sessions: Provides information about active sessions but not specifically about transaction rollbacks.
see https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-database-transactions-transact-sql?view=sql-server-ver15
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.DP-203 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.
Podavenna
Highly Voted 3 years, 9 months agoSOF_15
Most Recent 11 months, 3 weeks agoe56bb91
11 months, 3 weeks agoAlongi
1 year, 1 month agokkk5566
1 year, 10 months agoJerrie86
2 years, 5 months agonicky87654
2 years, 5 months agodmitriypo
2 years, 7 months agoallagowf
2 years, 8 months agoDeeksha1234
2 years, 10 months agoladywhiteadder
3 years, 3 months ago