Microsoft · DP-300
Microsoft Entra authentication and principals
DP-300 · Lesson 7 of 22 · 58:30
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: Microsoft Entra authentication next to SQL authentication, the Microsoft Entra administrator and Entra-only authentication, logins in master and contained database users, managed identities, fixed and custom roles, the server roles of Azure SQL Database, and Windows and Kerberos authentication on virtual machines and Managed Instance. Includes three original practice questions.
Preview the topics
- Contoso’s three database administrators must all have Microsoft Entra administrator rights on the logical server, and the team changes often. What should the server’s Entra administrator be?
- Contoso’s prescriptions API runs in Azure App Service with a managed identity, and must read and write in one database, with no password anywhere. What should the DBA create?
- Contoso has moved every app to managed identities, and wants to make sure nobody can connect with a SQL login anymore, not even the SQL administrator. What should it turn on?