What data is collected when turning on Diagnostics in Azure Synapse SQL?
Question
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)
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answers: A, B and D.
The following diagram from Microsoft Azure Portal shows the data which will be collected.
/answer/img8.png)
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.
To know more, please refer to the docs below:
When you turn on diagnostics for a Synapse SQL pool in Azure Monitor logs, you can collect data about different types of events and activities happening in the SQL pool. Some of the data that can be collected are:
A. SQLSecurityAuditEvents: This data includes information about the security-related events that occur in the SQL pool. These events could include successful or failed login attempts, changes to user permissions, or any other security-related activities.
B. DmsWorkers: This data is related to the Data Migration Service (DMS) that can be used to migrate data to and from the SQL pool. It includes information about the workers that are used to perform the migration tasks, such as the worker ID, the status of the worker, and any errors that occurred during the migration process.
C. FailedRequests: This data includes information about any requests that failed to execute in the SQL pool. This could include queries that timed out, queries that returned errors, or any other requests that did not complete successfully.
D. ExecRequests: This data includes information about the queries that were executed in the SQL pool. This could include details about the query text, the duration of the query, and any errors that occurred during the execution of the query.
In summary, when you turn on diagnostics for a Synapse SQL pool in Azure Monitor logs, you can collect a variety of data about the activities and events happening in the SQL pool, including security-related events, migration-related data, information about failed requests, and details about the queries that are executed in the pool.