DP-300 Certification Practice Question #287

Question

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.
What should you run as part of the implementation?

Accepted Answer

The security requirement is to authenticate database users using Active Directory credentials. In Azure SQL Database, Microsoft Entra ID (formerly Azure AD) users are created as contained database users using the `CREATE USER [name] FROM EXTERNAL PROVIDER` syntax. This is the only clause that maps a database user to an Azure AD identity. All other options map to SQL authentication or Windows/certificate-based authentication, which are incompatible with the Azure AD requirement. Complete agreement across Suggested Answer, Most Voted, and all community comments.

More DP-300 practice questions