In this video, learn how to configure the SQL Advanced Threat Protection (ATP) feature. SQL Database ATP provides for discovery, classification, and protection of sensitive data, as well as managing your database vulnerabilities and detecting indicators of threat to databases.
- [Instructor] Configuring Azure SQL Database … Advanced Threat Protection, or ATP, … is a topic you may well see on the AZ-500 exam, … and there are two areas that are going to be … most important for you to be knowledgeable. … Number one is understanding … the value proposition of the service, … what features does it bring to the table. … And the other thing is how to configure the service, … which is actually not all that difficult. … So Azure SQL Database ATP can detect anomalous activities … like SQL injection attacks, … like access from an unusual location, … like access from an unfamiliar principal, … an unfamiliar identity or an application, … and brute-force SQL credentials, … and the service can actually alert you on any of the above. … So let's just switch over to the Azure portal … and look at how we can enable … and configure SQL Database Advanced Threat Protection. … So I'm going to click on SQL servers, … and then I'll pick an Azure SQL instance, … and in the center menu, …
- Configuring security policies
- Enabling data authentication and auditing
- Configuring security for storage accounts
- Configuring Azure AD authentication
- Configuring security for Cosmos DB and Azure Data Lake