You are planning to use Azure Monitor logs to investigate the workload trends and query execution. This solution will be set up using the Azure portal and will be using Log Analytics for Synapse SQL. You have identified the steps involved in setting up this. One of the steps involves turning on resource logs of the SQL data warehouse. Which of the following data will be collected while turning on Diagnostics? (Multiple Choice)

Answer options:

A.SQLSecurityAuditEvents
B.DmsWorkers
C.FailedRequests
D.ExecRequests

Correct Answers: A, B and D
The following diagram from Microsoft Azure Portal shows the data which will be collected. 

Options A, B and D are correct:They are included in the list of data collected.
Option C is incorrect: Failed request data is not collected.
Reference: 
To know more, please refer to the docs below: 

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal#turn-on-resource-logs