PL-900 Demonstrate the capabilities of Power Apps Practice Question
Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)
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
✓
Microsoft Dataverse
Option C, Microsoft Dataverse, is correct because it is a cloud-hosted service that canvas apps connect to natively through the built-in Dataverse connector, so no on-premises data gateway is required. Option D, SharePoint, is correct because SharePoint Online is a cloud service and canvas apps use the standard SharePoint connector to read and write lists and libraries directly without a gateway. Options A (SQL Server on-premises) and B (Oracle database on-premises) are not correct because on-premises databases are only reachable from Power Platform via the on-premises data gateway. Option E (SAP on-premises) is also not correct because on-premises SAP systems require the on-premises data gateway (or an equivalent secure bridge) to be accessed from a canvas app.
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
SQL Server on-premises resides inside the local network, so canvas apps require an on-premises data gateway to reach it. It is tempting because SQL Server is a first-class Power Apps connector, and it is the right choice when a gateway is deployed, but the question excludes gateway-mediated sources.
- ✗
Oracle database on-premises
Why it's wrong here
Oracle database on-premises is network-isolated, so canvas apps connect only via an on-premises data gateway. It is tempting because Oracle is a supported Power Apps connector, correct when a gateway bridges the network, but direct use without a gateway demands a cloud-hosted or built-in source.
- ✓
Microsoft Dataverse
Why this is correct
Microsoft Entra ID authenticates the canvas app user, and Dataverse is a first-party connector, so the app reaches it through the Power Platform service directly. No on-premises data gateway is required, satisfying the without-a-gateway constraint.
- ✓
SharePoint
Why this is correct
SharePoint is a cloud service reached through its first-party connector, so canvas apps query lists and libraries directly over the internet. No on-premises data gateway is needed, satisfying the without-a-gateway constraint; gateways are only required for on-premises sources.
- ✗
SAP on-premises
Why it's wrong here
SAP on-premises sits behind a corporate network boundary, so canvas apps reach it only through an on-premises data gateway. It is tempting because SAP connectors exist and are correct for cloud or gateway-bridged SAP landscapes, but direct connection requires a cloud-reachable endpoint without a gateway.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 701 original PL-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.