Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam

Exam AZ-500 topic 8 question 3 discussion

Actual exam question from Microsoft's AZ-500

Question #: 3
Topic #: 18

DRAG DROP -
You need to configure SQLDB1 to meet the data and application requirements.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer

Suggested Answer:

Reference:
https://docs.microsoft.com/en-gb/azure/azure-sql/database/authentication-aad-overview

by Rume at July 1, 2021, 5:48 p.m.

Comments

Submit Cancel

Sleazy

Highly Voted 2 years ago

Wrote the exam today and passed with a score of 760, 1 case study.. no labs or simulations at all! If you're reading this, all the best my friend!

upvoted 35 times

...

researched_answer_boi

Highly Voted 3 years, 11 months ago

Studied the reference link in Solution section and found the proper order to be: 1) From the Azure Portal, create an Azure AD administrator for LitwareSQLServer1. 2) In SQLDB1, create contained database users. 3) Connect to SQLDB1 by using Microsoft SQL Server Management Studio.

upvoted 29 times

ajaysharma2061

2 years, 3 months ago

How can you create contained database users without connecting to SSMS? I believe the order is correct in the given answer.

upvoted 4 times

...

AzureJobsTillRetire

2 years, 7 months ago

This cannot be right. SSMS (Microsoft SQL Server Management Studio) is the tool you use to do the database administration work, including creating contained database users.

upvoted 6 times

...

heatfan900

1 year, 10 months ago

2 and 3 should be swapped. YOU WOULD NEED TO LOGIN TO THE DB FIRST BEFORE YOU CAN CREATE A CONTAINER USER.

upvoted 2 times

...

somenick

2 years, 9 months ago

Order provided in the answer is correct. To create an Azure AD-based contained database user (other than the server administrator that owns the database), connect to the database

upvoted 8 times

...

ITFranz

Most Recent 1 year ago

Congratulations to all for reaching the end of the mock test. Long journey, but very enriching path. https://learn.microsoft.com/en-gb/azure/azure-sql/database/authentication-aad-overview?view=azuresql The configuration steps include the following procedures to configure and use Microsoft Entra authentication. Create and populate a Microsoft Entra tenant. Optional: Associate or change the current directory that is associated with your Azure Subscription. Create a Microsoft Entra administrator. Configure your client computers. Create contained database users in your database mapped to Microsoft Entra identities. Connect to your database with Microsoft Entra identities. Answer: ) create an Azure AD administrator for LitwareSQLServer1. 2) In SQLDB1, create contained database users. 3) Connect to SQLDB1 by using Microsoft SQL Server Management Studio.

upvoted 1 times

...

dc864d4

1 year, 2 months ago

My Case study isn't on here from test 5/24/2023

upvoted 1 times

dc864d4

1 year, 2 months ago

I redact this. My case study was Topic 9. Please remove both of these.

upvoted 2 times

...

Pamban

1 year, 2 months ago

You reached end of the page.. Congratulations all!!

upvoted 4 times

...

danielklein09

1 year, 3 months ago

Took the exam on 24 April 2024, these are still valid. Had 50 questions and 1 study case. 98% of questions are from here. Some questions had the answers in different order. On the exam page it is mentioned that exam questions will be updated on 30 April 2024. So take care, as long as they don't change the exam name (like: AZ-501, AZ-502) you should be safe with these. Cheers and good luck, don't forget - sharing is caring

upvoted 6 times

jacobtriestech

1 year, 3 months ago

Did you pass? I'm taking it tomorrow.

upvoted 2 times

...

c12

2 years, 1 month ago

1- From the Azure Portal, create an Azure AD administrator for LitwareSQLServer1 2- In SQLDB1, create contained database users 3- Connect to SQLDB1 by using Microsoft SQL Server Management Studio https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql&tabs=azure-powershell

upvoted 2 times

...

majstor86

2 years, 5 months ago

1.From the Azure portal, create an Azure AD administrator for LitwareSQLServer1 2. Connect to SQLDB1 by using SSMS 3. In SQLDB1, create contained database users

upvoted 7 times

xcapell

2 years, 2 months ago

I totally agree with you. See following link. https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql&tabs=azure-powershell Section "Connect to the database using SSMS or SSDT" To confirm the Azure AD administrator is properly set up, connect to the master database using the Azure AD administrator account. To provision an Azure AD-based contained database user (other than the server administrator that owns the database), connect to the database with an Azure AD identity that has access to the database.

upvoted 1 times

...