You need to get the following information: – The top 10…

DRAG DROP
You are monitoring a Microsoft Azure SQL data warehouse.
You need to get the following information:
– The top 10 longest running queries
– The distributed query plan for a specific query
Which dynamic management view should you use for each piece of information? To answer, drag the
appropriate dynamic management views to the correct pieces of information. 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:

DRAG DROP
You are monitoring a Microsoft Azure SQL data warehouse.
You need to get the following information:
– The top 10 longest running queries
– The distributed query plan for a specific query
Which dynamic management view should you use for each piece of information? To answer, drag the
appropriate dynamic management views to the correct pieces of information. 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:

Answer:

Explanation:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-monitor



Leave a Reply 0

Your email address will not be published. Required fields are marked *