Practice Test 1 | Microsoft Azure Security Technologies | AZ-500 | Dumps | Mock Test
View Case Study
You need to comply with the below requirement.
The company wants to use Azure AD identities. It wants to secure the connection between the Azure Web app “whizlabapp2020” and the Azure SQL database “whizlabdb1.”
Which of the following steps would you implement for this requirement? Choose two answers from the options given below.
A. In the Azure SQL database, create contained users
B. In the Azure Portal, create new database users
C. Connect to the database using SQL Server Management studio
D. In Azure AD, create a system assigned managed identity
Answer – A, D
To use Azure Active Directory authentication with SQL, you can go ahead and create contained users in the Azure SQL database.
To secure access from the application to the database, you need to use a managed identity.
The Microsoft documentation also has a tutorial on this.
Option B is incorrect since you need to use the SQL Server management studio to create the users.
Option C is incorrect here. Web app needs to interact with Azure SQL Server and there is no manual interaction required.
For more information on using the managed service identity and for Azure AD authentication with SQL databases, one can visit the below URL-
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication
Comments are closed, but trackbacks and pingbacks are open.