Skip to content

All certifications

SC-500 practice question on Secure Azure databases, 2026-11-06

Archived question for 2026-11-06. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.

A team enables auditing on an Azure SQL database and keeps the default audit action groups. Which activity does the audit log record?

Show the explanation

The default audit action groups are completed batches, successful database authentication and failed database authentication.

Each option

  • A (correct). Correct: The default groups cover completed batches and both kinds of database sign-in.
  • B. These groups are not on by default. It would be right after adding those action groups.
  • C. Defaults also include successful sign-ins and queries. It would be right for a custom, narrow policy.
  • D. Those operations are not default groups. It would be right for no default policy.

What this question tests

It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, action groups.

The published topics under this objective, so you can check what you have covered:

  • Azure SQL platform security
  • Auditing for SQL DB
  • Managed Instance
  • Defender for Databases coverage

More from the archive

Start a daily session

Several questions at a time, aimed at your gaps.