Exam AZ-305 All QuestionsBrowse all questions from this exam
Go to 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:

    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
SilverFox22

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

FrancisFerreira

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

It has no VPN connection, not Internet.

PN117

"Server is prevented from accessing the internet."

NotMeAnyWay

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

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

On the AZ 305 exam, 28/11/22

tunmise_ay

was in exam 1 June 2022

tictaclu

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.

Contactfornitish

Came in exam today 4/4/2022

akkrishna22

on exam 03-31-2022

OPT_001122

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

bd1234

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

please delete above

ronin201

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

Afz

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

AubinBakana

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

Gor

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

moadabdou

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.

funlove15

correct

orionduo

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

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

please delete above

Teringzooi

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