ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 4 question 6 discussion

Actual exam question from Microsoft's AZ-305
Question #: 6
Topic #: 4
[All AZ-305 Questions]

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 Suggested Answer Hide 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 SilverFox22 at Jan. 1, 2022, 9:40 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
SilverFox22
Highly Voted 3 years, 5 months ago
The chosen answer is correct. https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection
upvoted 49 times
...
FrancisFerreira
Highly Voted 3 years, 3 months ago
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.
upvoted 24 times
ssgg100
2 years, 5 months ago
It has no VPN connection, not Internet.
upvoted 2 times
PN117
2 years, 4 months ago
"Server is prevented from accessing the internet."
upvoted 4 times
...
...
...
vrm1358
Most Recent 1 month, 3 weeks ago
Got this on may. 02, 2025 , Score 925, given answers are correct
upvoted 1 times
...
[Removed]
7 months, 2 weeks ago
CORRECT
upvoted 1 times
...
moadabdou
11 months, 3 weeks ago
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.
upvoted 1 times
...
ronin201
2 years ago
How on-prem GW connect to azure if no Internet on the server1? wrong description
upvoted 2 times
Afz
1 year, 9 months ago
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
upvoted 4 times
josola
9 months, 2 weeks ago
But it's the datacenter that has no connection to the Internet. So, at face value that wouldn't be the right answer. However, the question doesn't restrict having a data gateway with a dedicated VPN connection. This question is too convoluted.
upvoted 1 times
...
...
...
funlove15
2 years, 2 months ago
correct
upvoted 1 times
...
NotMeAnyWay
2 years, 2 months ago
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.
upvoted 19 times
...
omerco61
2 years, 4 months ago
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
upvoted 9 times
...
OPT_001122
2 years, 4 months ago
Box 1: An on-premises data gateway Box 2: A connection gateway resource
upvoted 3 times
bd1234
2 years, 3 months ago
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.
upvoted 1 times
bd1234
2 years, 3 months ago
please delete above
upvoted 1 times
...
...
...
orionduo
2 years, 4 months ago
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
upvoted 1 times
bd1234
2 years, 3 months ago
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.
upvoted 1 times
bd1234
2 years, 3 months ago
please delete above
upvoted 1 times
...
...
...
itvinoth83
2 years, 7 months ago
On the AZ 305 exam, 28/11/22
upvoted 7 times
...
AubinBakana
2 years, 11 months ago
Same solution applies for access to on-prem from the following Resources: Power Automate, - Power BI, - Power Apps, - Azure Analysis Services.
upvoted 2 times
...
tictaclu
2 years, 11 months ago
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.
upvoted 5 times
...
tunmise_ay
3 years ago
was in exam 1 June 2022
upvoted 7 times
...
Gor
3 years, 1 month ago
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
upvoted 2 times
...
Teringzooi
3 years, 2 months ago
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
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel