Skip to content

All certifications

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

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

A compliance team must find database columns that hold personal data, label them by sensitivity, and see in the audit log when labeled columns are read. Which feature supports this?

Show the explanation

Data discovery and classification labels columns, and audit logs record the sensitivity information of data that queries touch.

Each option

  • A. It hides values and gives no labels. It would be right for obscuring results.
  • B. It protects values from administrators and gives no labels. It would be right for keeping keys outside the engine.
  • C (correct). Correct: It labels columns, and audit records include the sensitivity of accessed data.
  • D. It lists configuration weaknesses and does not label data. It would be right for hardening review.

What this question tests

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

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.