Microsoft
DP-300 · Question #247
Hotspot Question You have an Azure subscription that is linked to an Azure Active Directory (Azure AD) tenant named contoso.com The subscription contains an Azure SQL database named SQL1 and an Azure
Sign in or unlock DP-300 to reveal the answer and full explanation for question #247. The question stem and answer options stay visible for context.
Submitted by certguy· Mar 6, 2026Perform administration by using T-SQL
Question
Hotspot Question You have an Azure subscription that is linked to an Azure Active Directory (Azure AD) tenant named contoso.com The subscription contains an Azure SQL database named SQL1 and an Azure web app named app1. App1 has the managed identity feature enabled. You need to create a new database user for app1. How should you complete the Transact-SQL statement? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
Exhibits
Answer Area
- CREATE USER
- FROMloginWindowsEXTERNAL PROVIDER
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.
Topics
#managed identity#CREATE USER#external provider#Azure AD authentication