Exam AZ-500 topic 3 question 20 discussion

Actual exam question from Microsoft's AZ-500

Question #: 20
Topic #: 3

SIMULATION -
You need to ensure that a user named Danny1234578 can sign in to any SQL database on a Microsoft SQL server named web1234578 by using SQL Server
Management Studio (SSMS) and Azure Active Directory (Azure AD) credentials.
To complete this task, sign in to the Azure portal.

Show Suggested Answer

Suggested Answer: See the explanation below.
You need to provision an Azure AD Admin for the SQL Server.
1. In the Azure portal, type SQL Server in the search box, select SQL Server from the search results then select the server named web1234578. Alternatively, browse to SQL Server in the left navigation pane.
2. In the SQL Server properties page, click on Active Directory Admin.
3. Click the Set Admin button.
4. In the Add Admin window, search for and select Danny1234578.
5. Click the Select button to add Danny1234578.
6. Click the Save button to save the changes.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell

by F117A_Stealth at Nov. 10, 2022, 2:31 p.m.

Comments

Submit Cancel

F117A_Stealth

Highly Voted 2 years, 5 months ago

Confirmed in Prod, this is correct. Steps are right.

upvoted 7 times

...

schpeter_091

Most Recent 5 months, 1 week ago

In case, don't forget to untick the "Microsoft Entra authentication only"

upvoted 1 times

...

pentium75

9 months ago

But "sign in to any SQL database" does not necessarily mean that he should have admin permissions ...

upvoted 3 times

...

Alagong

1 year ago

SQL Servers > Microsoft Entra ID > Set admin

upvoted 2 times

...

Rachy

1 year, 9 months ago

steps are correct