nerdexam
Microsoft

AZ-801 · Question #45

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…

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

How the community answered

(62 responses)
  • A
    16% (10)
  • B
    5% (3)
  • C
    8% (5)
  • D
    71% (44)

Why each option

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.

Aan Azure SQL managed instance

An Azure SQL managed instance requires migrating the database to Azure, which contradicts the requirement for the database to remain on-premises.

Ban on-premises data gateway

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.

CAzure Extended Network

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.

Da Hybrid ConnectionCorrect

A Hybrid Connection, utilizing Azure Relay, establishes a secure, two-way, port-based TCP tunnel between an Azure App Service web app and an on-premises resource like a SQL Server database, without requiring a VPN or exposing the on-premises database to the internet.

Concept tested: Azure App Service hybrid connectivity

Source: 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.

Sign up to join the discussion
Full AZ-801 Practice