Configure Azure for Accessing On-Premises Microsoft SQL Server Database
Question
You have an on-premises server that runs Windows Server and has the Web Server (IIS) server role installed. The server hosts a web app that connects to an on- premises Microsoft SQL Server database.
You plan to migrate the web app to an Azure App Services web app. The database will remain on-premises.
You need to ensure that the migrated web app can access the database.
What should you configure in Azure?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.D
https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connectionsOption B, an on-premises data gateway, should be configured in Azure to ensure that the migrated web app can access the database.
Explanation: When you migrate the web app to Azure App Services, the web app will run on Azure and will not have access to the on-premises database by default. Therefore, you need to establish a connection between the web app and the database to ensure that the web app can access the data. One way to do this is to use an on-premises data gateway.
An on-premises data gateway is a software component that acts as a bridge between Azure services and on-premises data sources. It allows you to securely transfer data between your on-premises data sources and your Azure services over a secure connection. In this case, the on-premises data gateway will allow the Azure App Services web app to securely access the on-premises Microsoft SQL Server database.
Option A, an Azure SQL managed instance, is not the correct answer because it refers to a fully managed version of Microsoft SQL Server that runs in Azure. It is designed for scenarios where you want to migrate your SQL Server workloads to Azure and manage them as a fully managed service.
Option C, Azure Extended Network, is also not the correct answer because it is not a specific Azure service. It is a general term that refers to the extension of your on-premises network to Azure using a VPN or ExpressRoute connection.
Option D, a Hybrid Connection, is not the correct answer because it is used to connect an Azure App Services web app to an on-premises application or service that runs on a specific port. It is not designed to connect to a database.
