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 use

Question

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.

• A
  5% (1)
• B
  71% (15)
• D
  10% (2)
• E
  14% (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

No community discussion yet for this question.