Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam

Exam AZ-304 topic 5 question 49 discussion

Actual exam question from Microsoft's AZ-304

Question #: 49
Topic #: 5

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:

Show Suggested Answer

Suggested Answer:

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

by AlanJP at July 3, 2021, 8 a.m.

Comments

Submit Cancel

AlanJP

Highly Voted 3 years, 11 months ago

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

upvoted 18 times

...

syu31svc

Highly Voted 3 years, 8 months ago

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

upvoted 14 times

rdemontis

3 years, 6 months ago

thanks for explanation

upvoted 3 times

...

Dpejic

Most Recent 3 years, 5 months ago

Appere on exam 23-dec-2021

upvoted 3 times

...

waqas

3 years, 8 months ago

Given answer is correct.

upvoted 3 times

...

Ram9533

3 years, 9 months ago

First question - Hybrid connection manager is thr correct Answer

upvoted 3 times

J4U

3 years, 8 months ago

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

upvoted 2 times

J4U

3 years, 8 months ago

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.

upvoted 6 times

...

sukhdeep

3 years, 10 months ago

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

upvoted 3 times

BoxGhost

3 years, 9 months ago

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

upvoted 3 times

...