nerdexam
Microsoft

PL-600 · Question #172

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. This solution is insufficient because a custom connector alone cannot directly bridge the connection from a cloud flow to an on-premises SQL Server database without an on-premises data gateway.

Submitted by javi_es· Apr 18, 2026Architect a solution

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company plans to automate the expense approval process. Users currently enter data into an on-premises SQL Server database. You need to allow users to submit expenses from mobile devices. Solution: Create a canvas app for expense data entry. Create a custom connector. Create a cloud flow for approval and use the custom connector to add data to the SQL Server database. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(30 responses)
  • A
    30% (9)
  • B
    70% (21)

Why each option

This solution is insufficient because a custom connector alone cannot directly bridge the connection from a cloud flow to an on-premises SQL Server database without an on-premises data gateway.

AYes

The solution fails to include the essential on-premises data gateway, which is required to establish connectivity between Power Automate cloud flows and on-premises SQL Server databases.

BNoCorrect

Custom connectors are typically used for web services or APIs; to connect a cloud flow to an on-premises SQL Server database, an on-premises data gateway is a mandatory component, which is missing from this solution.

Concept tested: Custom Connector vs. On-premises Data Gateway

Source: https://learn.microsoft.com/en-us/power-automate/gateway-manage

Topics

#Power Apps Canvas App#Power Automate#On-premises data integration#Custom Connectors

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice