Microsoft
DP-300 · Question #299
You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by…
The correct answer is A. From the Azure Active Directory admin center create a service principal. C. On SQL1, create a SQL user in the databases. https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal- tutorial?view=azuresql
Submitted by ricky.ec· Mar 6, 2026Implement a secure environment
Question
You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts. Which two accounts should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AFrom the Azure Active Directory admin center create a service principal.
- BFrom the Azure Active Directory admin center, create a user-assigned managed identity for
- COn SQL1, create a SQL user in the databases.
- DOn SQL1, create a SQL login.
- EFrom the Azure Active Directory admin center, create an external identity.
How the community answered
(44 responses)- A77% (34)
- B9% (4)
- D2% (1)
- E11% (5)
Explanation
https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal- tutorial?view=azuresql
Community Discussion
No community discussion yet for this question.