PrepAway - Latest Free Exam Questions & Answers

Which dynamic management view should you review for eac…

DRAG DROP
You have a Microsoft Azure SQL data warehouse.
Users discover that reports running in the data warehouse take longer than expected to complete.
You need to review the duration of the queries and which users are running the queries currently.
Which dynamic management view should you review for each requirement? To answer, drag the appropriate
dynamic management views to the correct requirements. Each dynamic management view may be used once,
more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-pdwexec-requests-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-pdwexec-sessions-transact-sql


Leave a Reply