AZ-500 · Question #157
AZ-500 Question #157: Real Exam Question with Answer & Explanation
Sign in or unlock AZ-500 to reveal the answer and full explanation for question #157. The question stem and answer options stay visible for context.
Question
SIMULATION You need to ensure that a user named Danny11597200 can sign in to any SQL database on a Microsoft SQL server named web11597200 by using SQL Server Management Studio (SSMS) and Azure Active Directory (Azure AD) credentials. To complete this task, sign in to the Azure portal. Answer: 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 web11597200. 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 Danny11597200. 5. Click the Select button to add Danny11597200. 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
Options
- Adevice configuration policies in Microsoft Intune
- Ban Azure Desired State Configuration (DSC) virtual machine extension
- Csecurity policies in Azure Security Center
- DAzure Logic Apps
Unlock AZ-500 to see the answer
You've previewed enough free AZ-500 questions. Unlock AZ-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.