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

AZ-305 Exam - Question 140

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. Server is prevented from accessing the internet.

An Azure logic app resource 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 Answer
Correct 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

Discussion

17 comments
Sign in to comment
SilverFox22
Jan 1, 2022

The chosen answer is correct. https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection

FrancisFerreira
Mar 28, 2022

Okay, got this wrong. Thought the solution was to build around AD Application Proxy. Mainly coz I couldn't wrap my head around the fact that Server1 has no internet connectivity. Well, turns out we don't need to install the On-Prem Data Gateway on the same computer as our data source. So yeah, we could install it on any other machine (that's not a domain controller) that has access to internet and is on the same network as Server1. https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-install#prerequisites The highlighted answers are correct.

ssgg100
Jan 11, 2023

It has no VPN connection, not Internet.

PN117
Feb 5, 2023

"Server is prevented from accessing the internet."

NotMeAnyWay
Apr 2, 2023

1. On-premises? c. an on-premises data gateway An on-premises data gateway allows you to securely access on-premises data and resources from Azure Logic Apps. In this scenario, deploying an on-premises data gateway on Server1 or another server in the datacenter will enable LogicApp1 to access the SQL Server 2016 database on Server1. 2. Azure? a. A connection gateway resource In Azure, you should deploy a connection gateway resource. This gateway resource will communicate with the on-premises data gateway to provide LogicApp1 with the ability to access the SQL Server 2016 database on Server1 securely.

omerco61
Feb 12, 2023

Correct Answer; Look architecture https://www.biinsight.com/wp-content/uploads/2018/03/On-prem-Data-Gateway-for-Azure-AS-How-it-works-Demo.png

itvinoth83
Nov 28, 2022

On the AZ 305 exam, 28/11/22

tunmise_ay
Jun 2, 2022

was in exam 1 June 2022

Contactfornitish
Apr 4, 2022

Came in exam today 4/4/2022

tictaclu
Jul 9, 2022

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. You can then select this gateway resource in the triggers and actions that you want to use for the on-premises connectors available in Azure Logic Apps. Azure VPN gateway is used to connect only to IAAS such as VM, VMSS which has Private IP address from On-Prem to Azure. The communication is over IKE protocol. You need a Gateway in Azure as well as a VPN device in On-Prem to connect using this mode. Using On-Prem Data Gateway you can communicate to Azure SAAS and PAAS services over HTTP/HTTPS. You only need Gateway at On-Premises, no gateway is required in Azure end.

akkrishna22
Mar 31, 2022

on exam 03-31-2022

OPT_001122
Feb 11, 2023

Box 1: An on-premises data gateway Box 2: A connection gateway resource

bd1234
Mar 16, 2023

I mean OPT answer is right. Create a new resource group or select an existing one where you want to deploy the Logic App. Create a new Logic App resource in the selected resource group. In the Logic App Designer, add a new trigger for the Logic App, such as the Recurrence trigger or any other trigger that suits your needs. Add a new action to the Logic App and select the SQL Server connector. Configure the SQL Server connector to connect to the SQL Server instance running on Server1 through the On-premises data gateway. Define the action to be taken on the database once the connection is established. In this case, it could be writing data to the SQL Server database. Save and test the Logic App to ensure that it is working correctly.

bd1234
Mar 16, 2023

please delete above

Gor
May 24, 2022

On-Premises: On-Premises Data Gateway Azure: Connection Gateway Resource https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-install#prerequisites

AubinBakana
Jul 26, 2022

Same solution applies for access to on-prem from the following Resources: Power Automate, - Power BI, - Power Apps, - Azure Analysis Services.

ronin201
Jun 11, 2023

How on-prem GW connect to azure if no Internet on the server1? wrong description

Afz
Sep 21, 2023

The server might not direct internet but on-premises data gateway can be installed in another instance which has internet and that can also connect to Server 1

Teringzooi
Apr 27, 2022

Correct! https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-install#prerequisites

orionduo
Feb 9, 2023

The answer is right 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. The gateway works as a bridge that provides quick data transfer and encryption between data sources on premises and your logic apps. The on-premises data gateway depends on Azure Service Bus Messaging for cloud connectivity and establishes the corresponding outbound connections to the gateway's associated Azure region. https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-install https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure?tabs=consumption

bd1234
Mar 16, 2023

I hope everyone pay attention on this correct answer: Create a new resource group or select an existing one where you want to deploy the Logic App. Create a new Logic App resource in the selected resource group. In the Logic App Designer, add a new trigger for the Logic App, such as the Recurrence trigger or any other trigger that suits your needs. Add a new action to the Logic App and select the SQL Server connector. Configure the SQL Server connector to connect to the SQL Server instance running on Server1 through the On-premises data gateway. Define the action to be taken on the database once the connection is established. In this case, it could be writing data to the SQL Server database. Save and test the Logic App to ensure that it is working correctly.

bd1234
Mar 16, 2023

please delete above

funlove15
Apr 5, 2023

correct

moadabdou
Jul 12, 2024

Sometimes your workflow must connect to an on-premises data source and can use only connectors that provide this access through an on-premises data gateway. To set up this on-premises data gateway, you have to complete the following tasks: install the local on-premises data gateway and create an on-premises data gateway resource in Azure for the local data gateway. When you add a trigger or action to your workflow from a connector that requires the data gateway, you can select the data gateway resource to use with your connection.