Question 199

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts. Which two accounts should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• AFrom the Azure Active Directory admin center create a service principal.
• BFrom the Azure Active Directory admin center, create a user-assigned managed identity for SQL1.
• COn SQL1, create a SQL user in the databases.
• DOn SQL1, create a SQL login.
• EFrom the Azure Active Directory admin center, create an external identity.