Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 3 Question 120 Discussion

SIMULATIONTask 7You 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.
A) See the explanation part fo rthe complete Solution

Microsoft DP-300 Exam - Topic 3 Question 120 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 120
Topic #: 3
[All DP-300 Questions]

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.

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Salome
3 months ago
I agree, understanding the runbook is key.
upvoted 0 times
...
Nell
4 months ago
I feel confident about configuring sq1370O6895.
upvoted 0 times
...
Isaac
4 months ago
It seems straightforward if you know Azure AD.
upvoted 0 times
...
Jennie
4 months ago
I’m not sure about the explanation part.
upvoted 0 times
...
Melodie
4 months ago
I think option A is the best choice.
upvoted 0 times
...
Huey
4 months ago
I'm not sure if this will work as expected, seems too easy!
upvoted 0 times
...
Katie
5 months ago
Wait, can we really create users directly from Azure AD?
upvoted 0 times
...
Karrie
5 months ago
Totally agree, this should simplify user management!
upvoted 0 times
...
Mireya
5 months ago
Sounds straightforward, but what about permissions?
upvoted 0 times
...
Sharee
5 months ago
Haha, "sq1370O6895"? Sounds like someone had a little fun with the naming there.
upvoted 0 times
...
Felix
6 months ago
Ah, I see what they're getting at. Gotta love those automation runbooks!
upvoted 0 times
...
Ezekiel
6 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
6 months ago
That's a tricky one! I bet the answer involves some Azure AD magic.
upvoted 0 times
...
Vannessa
6 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
6 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
6 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
7 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
7 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
7 months ago
You need to set up Azure AD integration first.
upvoted 0 times
...
Denae
7 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
...
Elza
8 months ago
This question is tricky.
upvoted 0 times
...
Elliot
8 months ago
I think we need to enable Azure AD authentication on the SQL server, but I can’t recall if there are specific permissions required for the runbook.
upvoted 0 times
...
Miles
8 months ago
Okay, I think I know the general approach, but I'll need to double-check the specific permissions and settings required.
upvoted 0 times
...
Maira
8 months ago
Hmm, this seems like a straightforward task, but I'll need to review the Azure AD and SQL Server configuration steps carefully.
upvoted 0 times
Destiny
3 months ago
Let’s make sure we test everything before going live.
upvoted 0 times
...
Rochell
3 months ago
I’ll review the automation scripts too.
upvoted 0 times
...
Iola
3 months ago
Don't forget about the SQL Server settings!
upvoted 0 times
...
Gearldine
3 months ago
Right! Azure AD setup is crucial here.
upvoted 0 times
...
Fernanda
7 months ago
Sounds simple enough! Just need to check the permissions.
upvoted 0 times
...
...

Save Cancel