Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.
You plan to use contained database user so that your Azure App Service can access Azure SQL Database. What do you need to do?
Experience Level: Junior
Tags: Azure App serviceAzure CloudAzure SQL Database
Answer
- Assign system-assigned managed identity to your App Service
- Create a contained user in Azure SQL Database and map it to the App Service managed identity principal
- Update your application source code to support Azure AD authentication
- Update your connection string
Related Azure Cloud job interview questions
What permission do you need to read a secret in Azure Key Vault?
Azure App serviceAzure CloudAzure SQL Database JuniorYou have an Azure Virtual Machine VM1 in West Europe and Azure Key Vault in East US. You want the VM1 store secrets to the Key Vault? What do you need to do?
Azure App serviceAzure CloudAzure SQL Database JuniorYou need to configure a network access for your Azure Key Vault. What role do you need?
Azure CloudAzure Key Vault JuniorWhat built-in user role do you need to to delegate permissions to Azure Key Vault?
Azure CloudAzure Key Vault JuniorYou want your application be able to access blob in Azure Storage account by using Azure Active Directory authentication. What do you need to do?
Azure Active DirectoryAzure CloudAzure Storage Junior
