
Ultimate access to all questions.
You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 is configured to send diagnostic logs to la1.
You need to determine if a recently executed query on Pool1 utilized the result set cache.
What are two different methods to accomplish this? Each correct answer provides a complete solution.
NOTE: Each correct selection is worth one point.
A
Review the sys.dm_pdw_sql_requests dynamic management view in Pool1.
B
Review the sys.dm_pdw_exec_requests dynamic management view in Pool1.
C
Use the Monitor hub in Synapse Studio.
D
Review the AzureDiagnostics table in la1.
E
Review the sys.dm_pdw_request_steps dynamic management view in Pool1.