DP-203 · Question #391
You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 sends logs to la1. You need to identify whether a recently executed query on Pool1…
The correct answer is B. Review the sys.dm_pdw_exec_requests dynamic management view in Pool1. C. Use the Monitor hub in Synapse Studio. The sys.dm_pdw_exec_requests dynamic management view provides details about currently or recently executed requests, and the Monitor hub in Synapse Studio can offer insights into the query execution and caching…
Question
You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 sends logs to la1. You need to identify whether a recently executed query on Pool1 used the result set cache. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- AReview the sys.dm_pdw_sql_requests dynamic management view in Pool1.
- BReview the sys.dm_pdw_exec_requests dynamic management view in Pool1.
- CUse the Monitor hub in Synapse Studio.
- DReview the AzureDiagnostics table in la1.
- EReview the sys.dm_pdw_request_steps dynamic management view in Pool1.
How the community answered
(21 responses)- A5% (1)
- B71% (15)
- D10% (2)
- E14% (3)
Explanation
The sys.dm_pdw_exec_requests dynamic management view provides details about currently or recently executed requests, and the Monitor hub in Synapse Studio can offer insights into the query execution and caching. https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-using- https://learn.microsoft.com/en-us/sql/t-sql/statements/set-result-set-caching-transact- sql?view=azure-sqldw-latest https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-pdw-exec-requests-transact-sql?view=aps-pdw-2016-au7
Topics
Community Discussion
No community discussion yet for this question.