Skip to content

All certifications

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

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

A company wants to disable SQL logins on its Azure SQL logical server so that only Microsoft Entra identities can authenticate. Which setting should the engineer enable?

Show the explanation

Microsoft Entra-only authentication turns off SQL authentication on the server and requires Microsoft Entra identities.

Each option

  • A. It encrypts data at rest and does not change authentication. It would be right for encrypting files.
  • B (correct). Correct: With Entra-only authentication, SQL authentication is disabled and only Microsoft Entra identities can sign in.
  • C. It hides values in results and does not control sign-in. It would be right for limiting data exposure.
  • D. It controls network admission and not authentication method. It would be right for service connectivity.

What this question tests

It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql platform, entra auth.

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.