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, …
Author
Pete Zerger
Updated
9/23/2020Released
4/29/2020- 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
Skill Level Intermediate
Duration
Views
-
Introduction
-
Exam overview32s
-
1. Configure Security Policies to Manage Data
-
2. Configure Security for Data Infrastructure
-
Enable database auditing2m 31s
-
Conclusion
-
Next steps1m 7s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Configure Azure SQL Database Advanced Threat Protection