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.
To identify whether a recently executed query on Pool1 used the result set cache, you can review the sys.dm_pdw_exec_requests dynamic management view, which provides details about currently or recently executed requests, including cache usage. Additionally, the sys.dm_pdw_request_steps dynamic management view offers detailed information about query execution steps, which can help determine if the result set cache was utilized.
Correct https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-using-azure-monitor 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
ChatGPT 4o To identify whether a recently executed query on Pool1 used the result set cache, you can use the following methods: B. Review the sys.dm_pdw_exec_requests dynamic management view in Pool1. D. Review the AzureDiagnostics table in la1.
B and E provides information about query caching
The Monitor hub in Synapse Studio does not provide information to verify cache utilization.
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.