Microsoft
DP-300 · Question #279
Hotspot Question You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD service principal named app1. You need to ensure th
Sign in or unlock DP-300 to reveal the answer and full explanation for question #279. The question stem and answer options stay visible for context.
Submitted by carlos_mx· Mar 6, 2026Perform administration by using T-SQL
Question
Hotspot Question You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD service principal named app1. You need to ensure that app1 can access db1. The solution must use the principle of least privilege. 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:
Exhibit
Answer Area
- CREATECREDENTIALLOGINUSER
- [app1]FOR LOGIN app1FROM EXTERNAL PROVIDERFROM LOGIN app1WITHOUT LOGIN
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
#CREATE USER#external provider#Azure AD service principal#contained database user