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:
Reference:
https://docs.microsoft.com/en-gb/azure/azure-sql/database/authentication-aad-overview
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.
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
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.
How can you create contained database users without connecting to SSMS? I believe the order is correct in the given answer.
2 and 3 should be swapped. YOU WOULD NEED TO LOGIN TO THE DB FIRST BEFORE YOU CAN CREATE A CONTAINER USER.
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!
https://www.examtopics.com/discussions/microsoft/view/9125-exam-az-500-topic-11-question-3-discussion/
Agree that given answer is correct.
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
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.
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
Did you pass? I'm taking it tomorrow.
Correct Ans
You reached end of the page.. Congratulations all!!
In Exam 8/4/2021.
Exam - 4/11/21
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
My Case study isn't on here from test 5/24/2023
I redact this. My case study was Topic 9. Please remove both of these.
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.