In this video, learn about configuring auditing of database access and modification events. The audit trail is a key element of supporting audit, as well as security incident response when necessary.
- [Instructor] You may encounter questions … around database auditing for Azure SQL on the AZ-500 exam … and by association, be indirectly tested on your knowledge … of server level audit settings in Azure SQL. … So we'll talk about both of those now. … So at a high level you can use database auditing … in Azure SQL to retain an audit trail of events, … we can report on that database activity. … So if we send those events to a log analytics instance … for example we can use Kusto queries … to query and report on that data, … visualize that data, generate alerts on that data, … and to that end we can analyze that data … for unusual activities, for trends, … for even suspicious events. … It's important to understand … how your server level audit settings … and your database level settings apply and interact. … So at a high level, server policy applies to both existing … and new databases. … So remember that. … And if server blob auditing is enabled, … it always applies to your databases. …
- 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