Exam SC-500 Topic 1 Question 56 Discussion

Actual exam question for Microsoft's SC-500 exam
Question #: 56
Topic #: 1
You have an Azure SQL Database logical server named Server1 that contains multiple databases.
The databases contain legacy SQL authentication logins that must no longer be usable for sign-in but must NOT be removed from the databases.
You need to ensure that SQL authentication is denied for connections.
What should you do?

Suggested Answer: C Vote an answer

Microsoft Entra-only authentication on an Azure SQL logical server disables SQL authentication for all databases hosted on that server. Existing SQL authentication logins remain in the databases, but they can no longer be used to establish connections because only Microsoft Entra identities are accepted for authentication.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql&tabs=azure-portal

by Ternence at Jun 23, 2026, 05:34 PM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

Contact Us

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday

Support: Contact now 

日本語 Deutsch 繁体中文 한국어