AZ-204 Question #41: Real Exam Question with Answer & Explanation

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.

Explanation

Use Dynamic Management Views (DMVs) in SQL DB to monitor status and progress of your ongoing elastic database transactions. These DMVs are particularly useful: sys.dm_tran_active_transactions: Lists currently active transactions and their status. The UOW (Unit Of Work) column can identify the different child transactions that belong to the same distributed transaction. All transactions within the same distributed transaction carry the same sys.dm_tran_database_transactions: Provides additional information about transactions, such as placement of the transaction in the log. sys.dm_tran_locks: Provides information about the locks that are currently held by ongoing transactions References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview

No community discussion yet for this question.