AZ-304 Exam QuestionsBrowse all questions from this exam
Go to Exam

AZ-304 Exam - Question 203

HOTSPOT -

You have an Azure subscription named Subscription1 that is linked to a hybrid Azure Active Directory (Azure AD) tenant.

You have an on-premises datacenter that does NOT have a VPN connection to Subscription1. The datacenter contains a computer named Server1 that has

Microsoft SQL Server 2016 installed. Server1 is prevented from accessing the internet.

An Azure logic app named LogicApp1 requires write access to a database on Server1.

You need to recommend a solution to provide LogicApp1 with the ability to access Server1.

What should you recommend deploying on-premises and in Azure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Exam AZ-304 Question 203
Show Answer
Correct Answer:
Exam AZ-304 Question 203

Box 1: An on-premises data gateway

For logic apps in global, multi-tenant Azure that connect to on-premises SQL Server, you need to have the on-premises data gateway installed on a local computer and a data gateway resource that's already created in Azure.

Box 2: A connection gateway resource

Reference:

https://docs.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure

Discussion

6 comments
Sign in to comment
AlanJP
Jul 3, 2021

The given answer seems to be correct - good description here: https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection

syu31svc
Oct 4, 2021

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-install Before you can connect to on-premises data sources from Azure Logic Apps, download and install the on-premises data gateway on a local computer. https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection After you install the on-premises data gateway on a local computer and before you can access data sources on premises from your logic apps, you have to create a gateway resource in Azure for your gateway installation Answer is correct

rdemontis
Dec 3, 2021

thanks for explanation

sukhdeep
Jul 27, 2021

Server does not have access to internet. how it can use on-premises data gateway.

BoxGhost
Aug 24, 2021

You can install it on another server on the same network that has internet access, like having a WAP server but in reverse.

Ram9533
Sep 6, 2021

First question - Hybrid connection manager is thr correct Answer

J4U
Sep 13, 2021

Agree with you. It's Hybrid Connection Manger as per these articles for an app service to connect to on-premise SQL server. https://azure.microsoft.com/sv-se/resources/videos/josh-twist-introduces-hybrid-connections/ https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway

J4U
Sep 13, 2021

Please ignore my previous comment. I go with On-Premises Data Gateway. Hybrid Connection is for App Services. On-Premises Data Gateway is for Logic Apps.

J4U
Sep 13, 2021

Please ignore my previous comment. I go with On-Premises Data Gateway. Hybrid Connection is for App Services. On-Premises Data Gateway is for Logic Apps.

waqas
Oct 8, 2021

Given answer is correct.

Dpejic
Dec 23, 2021

Appere on exam 23-dec-2021