SC-500: Implementing End-to-End Security Controls for Cloud and AI Workloads

By Microsoft · Question Mode

QuestionQ7

Manage identity, access, and governance

You have an Azure SQL Database logical server called Server1 that hosts multiple databases.

The databases contain legacy SQL authentication logins that must no longer be permitted to sign in, but must not be removed from the databases.

You need to deny connections that use SQL authentication.

What should you do?

Explanation

Microsoft Entra-only authentication disables SQL authentication at the Azure SQL logical-server level, preventing SQL authentication logins and users from connecting to any database on that server. Existing SQL authentication accounts remain in place; they are simply unable to sign in.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!