thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Database Auditing

Tracking and recording database events such as logins, queries, permission changes and data modifications for security and compliance.

Definition

Auditing tools include SQL Server Audit, Azure SQL Auditing (to storage, Log Analytics or Event Hubs), Oracle Unified Auditing and Snowflake's ACCESS_HISTORY and LOGIN_HISTORY views. Audit logs must be protected from tampering and retained to meet policy.

Exam tip

Azure SQL auditing can be configured at server level, applying to all databases, or at database level.

Related terms