nerdexam
Microsoft

PL-900 · Question #334

A large manufacturing company operates a single enterprise resource planning (ERP) application. The company uses SQL Server with an outdated web interface that does not work with modern browsers…

The correct answer is B. Connector D. Power Apps. To create a new Power Platform application interface for an existing SQL Server ERP while keeping data in place, Power Apps with a Connector is the recommended solution.

Submitted by tunde_lagos· Apr 18, 2026

Question

A large manufacturing company operates a single enterprise resource planning (ERP) application. The company uses SQL Server with an outdated web interface that does not work with modern browsers. The company requires a new application interface that uses the capabilities of Microsoft Power Platform. The key requirements for the solution are: - Users must be able to read/write data. - Due to data privacy concerns, all data must remain within the ERP application. - Where possible, costs must be minimized. You need to recommend platform features to implement the requirements. Which two features should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • ADataverse
  • BConnector
  • CPower BI report
  • DPower Apps
  • EDataflow

How the community answered

(35 responses)
  • A
    11% (4)
  • B
    80% (28)
  • C
    6% (2)
  • E
    3% (1)

Why each option

To create a new Power Platform application interface for an existing SQL Server ERP while keeping data in place, Power Apps with a Connector is the recommended solution.

ADataverse

Dataverse would require migrating or synchronizing the data into Dataverse, which violates the requirement that all data must remain within the existing ERP application (SQL Server).

BConnectorCorrect

A Power Platform connector allows Power Apps to directly connect to external data sources like SQL Server, enabling read/write operations on the existing ERP data without migrating it. This meets the requirement for data to remain within the ERP application.

CPower BI report

Power BI reports are for data visualization and analysis, not for creating interactive read/write application interfaces.

DPower AppsCorrect

Power Apps provides the capability to create modern, user-friendly interfaces (canvas or model-driven apps) that can connect directly to existing data sources via connectors. This satisfies the need for a new application interface that supports read/write capabilities and leverages Power Platform.

EDataflow

Dataflows are primarily for extracting, transforming, and loading data into Dataverse or other destinations, not for building a direct user interface to an existing data source for real-time read/write operations.

Concept tested: Power Apps with connectors for external data

Source: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/add-data-connection

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-900 Practice