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 using
Sign in or unlock DP-300 to reveal the answer and full explanation for question #299. The question stem and answer options stay visible for context.
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.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.