You have an Azure Synapse Analytics dedicated SQL pool named pool1.
You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative effort.
What should you include in the solution?
You have an Azure Synapse Analytics dedicated SQL pool named pool1.
You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative effort.
What should you include in the solution?
To perform a monthly audit of SQL statements that affect sensitive data in an Azure Synapse Analytics dedicated SQL pool, you should utilize Microsoft Defender for SQL. This tool provides advanced security features such as vulnerability assessment and threat protection. These capabilities help you monitor and audit SQL statements effectively, ensuring that any activity affecting sensitive data is tracked and managed efficiently, thus minimizing administrative effort.
Microsoft Defender for SQL is a tool that provides advanced SQL security capabilities, including vulnerability assessment, threat protection, and detection of anomalous activities that may indicate a security threat to your databases. However, for the specific need of auditing SQL statements affecting sensitive data, sensitivity labels are the more directly applicable feature.
Sensitivity Labels
Correct
Sensitivity labels will not help you with audit. It will secure your data but not help you with the SQL statements Microsoft Defender for Azure SQL helps you discover and mitigate potential database vulnerabilities and alerts you to anomalous activities that might be an indication of a threat to your databases. Vulnerability assessment: Scan databases to discover, track, and remediate vulnerabilities. Learn more about vulnerability assessment. Threat protection: Receive detailed security alerts and recommended actions based on SQL Advanced Threat Protection to provide to mitigate threats. Learn more about SQL Advanced Threat Protection. https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-introduction
sensitive in ques= sensitive in options
Correct, chatgpt To conduct a monthly audit of SQL statements impacting sensitive data in Azure Synapse Analytics while minimizing administrative effort, include the use of Sensitivity Labels to classify sensitive data and utilize Microsoft Defender for SQL for advanced threat detection and monitoring of related activities. These tools will aid in governance and provide alerts for any suspicious access or manipulation of sensitive data. For a comprehensive approach to setting up these features, refer to the official Microsoft documentation for guidance.https://learn.microsoft.com/en-us/azure/synapse-analytics/