nerdexam
MicrosoftMicrosoft

AZ-801 · Question #45

AZ-801 Question #45: Real Exam Question with Answer & Explanation

The correct answer is D: a Hybrid Connection. To ensure an Azure App Service web app can securely access an on-premises SQL Server database without migrating the database, a Hybrid Connection should be configured.

Migrate servers and workloads

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?

Options

  • Aan Azure SQL managed instance
  • Ban on-premises data gateway
  • CAzure Extended Network
  • Da Hybrid Connection

Explanation

To ensure an Azure App Service web app can securely access an on-premises SQL Server database without migrating the database, a Hybrid Connection should be configured.

Common mistakes.

  • A. An Azure SQL managed instance requires migrating the database to Azure, which contradicts the requirement for the database to remain on-premises.
  • B. An on-premises data gateway is typically used for connecting Azure services like Logic Apps or Power BI to on-premises data sources, but Hybrid Connections are purpose-built for App Services to connect to on-premises resources.
  • C. Azure Extended Network is a feature for stretching on-premises network subnets into Azure for VM migration, not for an Azure App Service connecting to an on-premises database.

Concept tested. Azure App Service hybrid connectivity

Reference. https://learn.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections

Topics

#Azure App Services#Hybrid Connectivity#Hybrid Connections#On-premises SQL

Community Discussion

No community discussion yet for this question.

Full AZ-801 PracticeBrowse All AZ-801 Questions