Exam AZ-500 topic 5 question 25 discussion

the answer is correct. see https://www.sqlshack.com/advanced-data-security-in-azure-sql-database-data-discovery-classification/ however this feature has been renamed by Microsoft to Azure Defender for SQL

I would go for D. "Advanced Threat Protection provides a new layer of security, which enables customers to detect and respond to potential threats as they occur by providing security alerts on anomalous activities. Users receive an alert upon suspicious database activities, potential vulnerabilities, and SQL injection attacks, as well as anomalous database access and queries patterns." Source: https://docs.microsoft.com/en-gb/azure/azure-sql/database/threat-detection-overview

Both B and D is correct, considering what should be first, it should probably be B https://learn.microsoft.com/en-us/answers/questions/410488/azure-sql-advanced-data-security-vs-azure-defender#:~:text=.%20When%20you%20enable%20SQL%20ADS%20then%20you%20enable%20all%20of%20these%20included%20features%20like%20Data%20Discovery%20%26%20Classification%2C%20Vulnerability%20Assessment%20and%20Advanced%20Threat%20Protection%20and%20you%20can%20enable%20the%20Auditing%20as%20well.

Advanced data security for SQL that is now Microsoft Azure Defender for SQL

Correct answer should be ATP via Microsoft to Azure Defender for SQL.

B. Enable Advanced Data Security.

B. Enable Advanced Data Security. (Microsoft Defender for SQL/Cloud)

Should be B even though name has changed to Defender for SQL: "What are the benefits of Microsoft Defender for SQL? Microsoft Defender for SQL provides a set of advanced SQL security capabilities, including SQL Vulnerability Assessment and Advanced Threat Protection." https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?view=azuresql

I would go with D

ADS . Just google azure advanced data security. atp is included in it. ref:https://azure.microsoft.com/en-au/updates/advanced-data-security-for-sql-servers-on-azure-virtual-machines/

It's B for sure. Advanced Data Security is a set of tool (including ATP which is for monitoring). Another feature of ADS is Vulnerability assesment. This part is asked for this question.

Advanced Threat Protection provides a new layer of security, which enables customers to detect and respond to potential threats as they occur by providing security alerts on anomalous activities. Users receive an alert upon suspicious database activities, potential vulnerabilities, and SQL injection attacks, as well as anomalous database access and queries patterns. Advanced Threat Protection integrates alerts with Microsoft Defender for Cloud, which include details of suspicious activity and recommend action on how to investigate and mitigate the threat. Advanced Threat Protection makes it simple to address potential threats to the database without the need to be a security expert or manage advanced security monitoring systems.

Has to be B. D is Azure Advanced Threat Protection - now known as Defender for Identity

D is the Answer, you can enable Defender at Subscription level for all databases or each database level under security. https://docs.microsoft.com/en-gb/azure/azure-sql/database/azure-defender-for-sql?view=azuresql

https://docs.microsoft.com/en-gb/azure/azure-sql/database/azure-defender-for-sql

Question is outdated

Answer is correct. https://azure.microsoft.com/en-us/updates/advanced-data-security-for-sql-servers-on-azure-virtual-machines/ Microsoft Defender for Cloud provides a set of advanced SQL security capabilities, including SQL Vulnerability Assessment and Advanced Threat Protection. Is Microsoft Defender for Cloud that provides vulnerability assessment and not ATP. ATP is used to detects anomalous activities.