Skip to content

All certifications

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

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

Policy says auditing must stay enabled on every logical server in a subscription, and servers without it must be corrected automatically. Which control meets the requirement?

Show the explanation

DeployIfNotExists remediates by deploying the auditing configuration where it is missing, while Audit only flags noncompliance.

Each option

  • A. It reports servers without auditing and fixes nothing. It would be right for reporting only.
  • B. It stops deletion and does not enforce auditing. It would be right for protecting servers from removal.
  • C. It gives read access and changes nothing. It would be right for inspection.
  • D (correct). Correct: It deploys the auditing setting on servers that lack it.

What this question tests

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

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.