Skip to content

All certifications

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

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

Which feature encrypts Azure SQL Database data files and automated backups at rest by default?

Show the explanation

Transparent data encryption is on by default for new Azure SQL databases and encrypts data, log files and backups at rest.

Each option

  • A. It protects chosen columns with client-side keys and is not the default. It would be right for hiding data from administrators.
  • B (correct). Correct: It encrypts the database, its backups and log files without application changes.
  • C. It obscures query output and encrypts nothing. It would be right for limiting visible values.
  • D. It filters rows and encrypts nothing. It would be right for tenant isolation.

What this question tests

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

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.