Skip to content

All certifications

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

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

A company hosts many databases on one logical server and creates new ones weekly. Every database, current and future, must be audited without per-database work. What should the engineer do?

Show the explanation

A server-level auditing policy applies to all existing and newly created databases on that server.

Each option

  • A. It leaves new databases uncovered until someone repeats it. It would be right for one database with special events.
  • B (correct). Correct: A server policy applies to existing databases and to new ones.
  • C. It encrypts data at rest and records nothing. It would be right for file protection.
  • D. It scans for weaknesses and records no events. It would be right for configuration review.

What this question tests

It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, server 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.