You are a Solution Architect and need to evaluate the data sources for your Power Apps project. The project should read and write the data stored in Azure SQL Database and the Dataverse. Please select

The correct answer is B. Virtual table C. SQL Server Connector E. Dataflows. To read and write data in both Azure SQL Database and Dataverse, three valid approaches are: (B) Virtual tables, which project Azure SQL data as native Dataverse tables without physical migration, enabling read/write via Dataverse APIs; (C) the SQL Server Connector in Power Apps/

Submitted by miguelv· Apr 18, 2026Architect a solution

Question

You are a Solution Architect and need to evaluate the data sources for your Power Apps project. The project should read and write the data stored in Azure SQL Database and the Dataverse. Please select the three data sources that you can use in your solution.

Options

ACustom Connector
BVirtual table
CSQL Server Connector
DActivity table
EDataflows
FSharePoint Connector

How the community answered

(22 responses)

A
18% (4)
B
45% (10)
D
27% (6)
F
9% (2)

Explanation

To read and write data in both Azure SQL Database and Dataverse, three valid approaches are: (B) Virtual tables, which project Azure SQL data as native Dataverse tables without physical migration, enabling read/write via Dataverse APIs; (C) the SQL Server Connector in Power Apps/Power Automate, which connects directly to Azure SQL for read/write operations; and (E) Dataflows, which use Power Query to import and transform data from Azure SQL into Dataverse tables. Custom Connectors (A) require a REST/SOAP API, not a database connection. Activity tables (D) are a Dataverse entity category, not a data source. The SharePoint Connector (F) is for SharePoint, not SQL or Dataverse.

Topics

#Power Apps Connectors#Azure SQL Database Integration#Dataverse Virtual Tables#Power Platform Dataflows

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice