Exam DP-300 topic 2 question 27 discussion

Actual exam question from Microsoft's DP-300

Question #: 27
Topic #: 2

HOTSPOT
-

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.

Show Suggested Answer

Suggested Answer:

by BrenFa101 at Feb. 3, 2023, 4 p.m.

Comments

Submit Cancel

MLCLUB

Highly Voted 2 years, 5 months ago

Answer is correct. In T-SQL, just point to App name not managed identity. https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/tutorial-windows-vm-access-sql

upvoted 6 times

TheMCT

2 years, 4 months ago

The syntax: CREATE USER [App1] FROM EXTERNAL PROVIDER

upvoted 6 times

...

hussamAlHunaiti

Highly Voted 1 year, 11 months ago

hussam

upvoted 6 times

...

Natali

Most Recent 11 months, 1 week ago

[email protected] Just try to do it with own hands

upvoted 1 times

...

BrenFa101

2 years, 5 months ago

Thanks for clarification.

upvoted 3 times

...

BrenFa101

2 years, 5 months ago

I think it should be [[email protected]] App1 is not a user in the AD tenant - [email protected] is the proper principal name to be used.

upvoted 3 times

[Removed]

2 years, 5 months ago

Since the object is a managed identity, there's no UPN, you just give it the name of the resource ([App1] in this case). See an example with a VM MI here: https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/tutorial-windows-vm-access-sql#create-contained-user

upvoted 4 times

...

jm2015

1 year, 5 months ago

I am agree with you.

upvoted 1 times

...