PL-900 Demonstrate the capabilities of Power Apps Practice Question
Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
SharePoint Online
Option C (SharePoint Online) is correct because it is a cloud-based Microsoft 365 service that canvas apps connect to directly through the built-in SharePoint connector, with no on-premises data gateway required. Option E (Microsoft Dataverse) is correct because it is a native cloud data platform in Power Platform, and canvas apps use the standard Dataverse connector to access it directly without a gateway. Options A (SQL Server on-premises), B (SAP ERP on-premises), and D (Oracle database on-premises) are all on-premises systems, so reaching them from a canvas app requires an on-premises data gateway to bridge the cloud service to the local network.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SQL Server on-premises
Why it's wrong here
On-premises SQL Server sits behind a corporate network boundary, so canvas apps reach it only through an on-premises data gateway. It is tempting because SQL Server is a first-class Power Apps connector, and it would qualify if the database were Azure SQL or otherwise cloud-hosted.
- ✗
SAP ERP on-premises
Why it's wrong here
SAP ERP on-premises exposes data through the on-premises data gateway, since the canvas app cannot route directly into a private corporate network. It is tempting because SAP is a supported connector, and it would qualify if the SAP system were cloud-hosted rather than installed on-premises.
- ✓
SharePoint Online
Why this is correct
SharePoint Online is a cloud service reachable directly over the internet, so the canvas app's connector authenticates to it without any on-premises data gateway. The gateway is only needed for resources inside a private network.
- ✗
Oracle database on-premises
Why it's wrong here
An on-premises Oracle database requires the on-premises data gateway to bridge the canvas app to the private network. It is tempting because Oracle Database is a fully supported connector, and it would qualify if the instance were Oracle Cloud-hosted rather than running inside the corporate network.
- ✓
Microsoft Dataverse
Why this is correct
Microsoft Dataverse exposes a cloud-native connector, so canvas apps query it directly over the service endpoint without any gateway bridging on-premises networks. The stem's constraint — no on-premises data gateway — is satisfied because Dataverse tables reside entirely in Microsoft's cloud, requiring only standard authentication and connector configuration.
Visual reference
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.