DP-203 practice question 30 of 35
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?
Full set: 354 questionsYou can use Dynamic Management Views (DMVs) to monitor your workload including investigating query execution in SQL pool. If your queries are failing or taking a long time to proceed, you can check and monitor if you have any transactions rolling back.
Example: -- Monitor rollback SELECT SUM(CASE WHEN t.database_transaction_next_undo_lsn IS NOT NULL THEN 1 ELSE 0 END), t.pdw_node_id, nod.[type] FROM sys.dm_pdw_nodes_tran_database_transactions t JOIN sys.dm_pdw_nodes nod ON t.pdw_node_id = nod.pdw_node_id GROUP BY t.pdw_node_id, nod.[type]
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehousemanage-monitor#monitor-transaction-log-rollback
Keep practicing
Take the free DP-203 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DP-203 practice questions
- Question 1You have an Azure subscription that contains an Azure data factory named ADF1. From Azure…
- Question 2You need to implement the surrogate key for the retail store table. The solution must mee…
- Question 4You have an Azure Synapse Analytics dedicated SQL Pool1. Pool1 contains a partitioned fac…
- Question 5You need to design a data retention solution for the Twitter feed data records. The solut…
- Question 6You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the …
- Question 7You plan to implement an Azure Data Lake Storage Gen2 container that will contain CSV fil…
