nerdexam
Microsoft

PL-600 · Question #173

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 A. Yes. The proposed solution leverages a canvas app for mobile data entry, a cloud flow for orchestrating approvals, and a desktop flow to connect and write data to the on-premises SQL Server database, effectively meeting the requirements.

Submitted by kwame.gh· 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 desktop flow. Create a cloud flow for approval and trigger the desktop flow to add data to the SQL Server database. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(24 responses)
  • A
    71% (17)
  • B
    29% (7)

Why each option

The proposed solution leverages a canvas app for mobile data entry, a cloud flow for orchestrating approvals, and a desktop flow to connect and write data to the on-premises SQL Server database, effectively meeting the requirements.

AYesCorrect

A canvas app provides the mobile interface for users to submit expenses from their devices. A cloud flow can orchestrate the approval process and then trigger a desktop flow, which uses Power Automate's on-premises data gateway, to interact with the on-premises SQL Server database to add the expense data. This combination allows for mobile submission, cloud-based approval, and secure on-premises data integration.

BNo

Concept tested: Integrating Power Platform with on-premises data

Source: https://learn.microsoft.com/en-us/power-automate/desktop-flows/connect-sql-database

Topics

#Canvas Apps#Power Automate#Desktop Flows#On-premises Integration

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice