nerdexam
Microsoft

PL-600 · Question #170

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 successfully enables mobile users to submit expenses to an on-premises SQL Server database by combining a canvas app for data entry, an on-premises data gateway for secure connectivity, and a cloud flow for approval and data integration.

Submitted by helene.fr· 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 an on-premises gateway. Create a cloud flow for approval and to add data to the SQL Server database. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(32 responses)
  • A
    81% (26)
  • B
    19% (6)

Why each option

The proposed solution successfully enables mobile users to submit expenses to an on-premises SQL Server database by combining a canvas app for data entry, an on-premises data gateway for secure connectivity, and a cloud flow for approval and data integration.

AYesCorrect

A canvas app provides a mobile-friendly interface, an on-premises data gateway securely connects cloud services to the on-premises SQL Server, and a cloud flow handles approval and writes data, fulfilling all stated requirements.

BNo

The solution effectively leverages standard Power Platform components to meet the goals of mobile access, on-premises data integration, and workflow automation.

Concept tested: On-premises Data Integration with Power Platform

Source: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-sql-server

Topics

#Canvas Apps#Power Automate#On-premises Data Gateway#SQL Server Integration

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice