You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1.
You need to monitor Pool1. The solution must ensure that you capture the start and end times of each query completed in Pool1.
Which diagnostic setting should you use?
To monitor an Azure Synapse Analytics dedicated SQL pool and capture the start and end times of each query completed, you should use the 'Exec Requests' diagnostic setting. This setting provides detailed information about the execution of SQL queries, including their start and end times.
D seems correct, I was wondering if B could also be correct but apparently it only gives start and end times for the steps of a query and not for the query itself. Following link for reference : https://learn.microsoft.com/en-us/azure/azure-monitor/reference/supported-logs/microsoft-synapse-workspaces-sqlpools-logs
Information about SQL requests or queries in an Azure Synapse dedicated SQL pool.