nerdexam
Microsoft

PL-600 · Question #171

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. While a canvas app supports mobile data entry and a cloud flow handles approval, this solution fails to provide the necessary connection between the cloud flow and the on-premises SQL Server database.

Submitted by weili_xi· 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. Install the Power Automate app in Microsoft Teams. Create a cloud flow for approval to add data to the SQL Server database. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(44 responses)
  • A
    16% (7)
  • B
    84% (37)

Why each option

While a canvas app supports mobile data entry and a cloud flow handles approval, this solution fails to provide the necessary connection between the cloud flow and the on-premises SQL Server database.

AYes

The absence of an on-premises data gateway means the cloud flow cannot access the on-premises SQL Server, thus the solution does not meet the requirement to add data to that database.

BNoCorrect

The solution lacks an on-premises data gateway, which is essential for a cloud flow to securely connect and add data to an on-premises SQL Server database, making it incomplete for the stated goal.

Concept tested: On-premises Data Gateway Requirement

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

Topics

#Power Apps#Power Automate#On-premises data integration#Mobile solutions

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice