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?
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?
To monitor for transactions that have rolled back in a SQL pool in Azure Synapse, use the dynamic management view sys.dm_pdw_nodes_tran_database_transactions. This view provides detailed information about database transactions at the node level, including their state, which can help you identify transactions that have rolled back.
Correct Answer!
B. sys.dm_pdw_nodes_tran_database_transactions
Rollback works with transactions. answer B
Correct Answer!B. sys.dm_pdw_nodes_tran_database_transactions
The given answer is correct
correct
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
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.
I found this question on my exam 30/04/2024, and I put B. I passed the exam with a high score, but I'm not sure if the answer is correct.
correct