Microsoft DP-300 Exam - Topic 3 Question 120 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 120
Topic #: 3

SIMULATION

Task 7

You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sq1370O6895 to support the creation of new database users.

ASee the explanation part fo rthe complete Solution

Show Suggested Answer

Suggested Answer: A

To configure sq1370O6895 to support the creation of new database users from Azure AD identities, you need to do the following steps:

Set up a Microsoft Entra tenant and associate it with your Azure subscription.You can use the Microsoft Entra portal or the Azure portal to create and manage your Microsoft Entra users and groups12.

Configure a Microsoft Entra admin for sq1370O6895.You can use the Azure portal or the Azure CLI to set a Microsoft Entra user as the admin for the server34.The Microsoft Entra admin can create other database users from Microsoft Entra identities5.

Connect to db1 using the Microsoft Entra admin account and run the following Transact-SQL statement to create a new database user from a Microsoft Entra identity:CREATE USER [Microsoft Entra user name] FROM EXTERNAL PROVIDER;6You can replace the Microsoft Entra user name with the name of the user or group that you want to create in the database.

Grant the appropriate permissions to the new database user by adding them to a database role or granting them specific privileges. For example, you can run the following Transact-SQL statement to add the new user to the db_datareader role:ALTER ROLE db_datareader ADD MEMBER [Microsoft Entra user name];

These are the steps to configure sq1370O6895 to support the creation of new database users from Azure AD identities.

by Lovetta at Nov 22, 2025, 06:15 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Melodie

2 days ago

I think option A is the best choice.

upvoted 0 times

...

Huey

7 days ago

I'm not sure if this will work as expected, seems too easy!

upvoted 0 times

...

Katie

25 days ago

Wait, can we really create users directly from Azure AD?

upvoted 0 times

...

Karrie

1 month ago

Totally agree, this should simplify user management!

upvoted 0 times

...

Mireya

1 month ago

Sounds straightforward, but what about permissions?

upvoted 0 times

...

Sharee

1 month ago

Haha, "sq1370O6895"? Sounds like someone had a little fun with the naming there.

upvoted 0 times

...

Felix

2 months ago

Ah, I see what they're getting at. Gotta love those automation runbooks!

upvoted 0 times

...

Ezekiel

2 months ago

Hmm, I wonder if we need to configure some SQL Server settings too. This could be a multi-step process.

upvoted 0 times

...

Vanesa

2 months ago

That's a tricky one! I bet the answer involves some Azure AD magic.

upvoted 0 times

...

Vannessa

2 months ago

I feel like I’ve seen a question like this before, where we had to set up the correct roles for the database users. I hope I remember the right commands!

upvoted 0 times

...

Leota

2 months ago

This seems familiar; I believe we discussed using PowerShell scripts for creating users, but I’m uncertain about how to link it with Azure AD identities.

upvoted 0 times

...

Raylene

2 months ago

This looks manageable, but I want to make sure I understand all the prerequisites and the exact steps involved before I start coding.

upvoted 0 times

...

Marylyn

3 months ago

No problem, I've done something similar before. I'll review the documentation on integrating Azure AD with SQL Server and then put together the runbook.

upvoted 0 times

...

Mindy

3 months ago

I'm a bit unsure about how to configure SQL Server to support creating database users from Azure AD identities. I'll need to research that part.

upvoted 0 times

...

Reiko

3 months ago

You need to set up Azure AD integration first.

upvoted 0 times

...

Denae

3 months ago

I remember we practiced a similar question about automating user creation in Azure SQL, but I’m not sure about the exact steps for configuring the server.

upvoted 0 times

...