PL-900 Demonstrate the capabilities of Power Apps Practice Question
Which TWO data sources can be directly connected to a Power Apps canvas app without using an on-premises data gateway? (Choose two.)
⚠ Common exam trap
It's easy for candidates to confuse 'on-premises' data sources (which require a gateway) with cloud-based services like SharePoint Online and Outlook, mistakenly thinking all Microsoft data sources need a gateway, or overlooking that SharePoint Online is a cloud service.
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 365 Outlook
Microsoft 365 Outlook (option D) is a cloud-based service, so a canvas app can connect to it directly through the built-in Office 365 Outlook connector without any on-premises data gateway. SharePoint Online list (option E) is likewise a cloud-hosted data source, and the SharePoint connector supports direct connections from Power Apps canvas apps without a gateway. In contrast, Oracle Database on-premises (A), SAP on-premises (B), and SQL Server on-premises (C) all reside inside a private network, so they require an on-premises data gateway to be reached from Power Apps.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Oracle Database on-premises
Why it's wrong here
Oracle Database on-premises resides inside the corporate network, so connectivity from Power Apps requires the on-premises data gateway. It is tempting because Oracle is a supported connector, yet that connector serves cloud-hosted or gateway-bridged instances; the stem excludes any gateway, so this source cannot qualify.
- ✗
SAP on-premises
Why it's wrong here
SAP on-premises runs within the corporate network, so canvas apps connect to it only via the on-premises data gateway. It is tempting because SAP is a listed Power Apps connector, but that connector targets cloud or gateway-mediated SAP systems; the no-gateway constraint in the stem rules it out.
- ✗
SQL Server on-premises
Why it's wrong here
SQL Server on-premises sits behind a corporate network boundary, so canvas apps reach it only through the on-premises data gateway. It is tempting because SQL Server is a first-class Power Apps connector, but that connector targets Azure SQL Database or SQL Server exposed publicly; the gateway requirement is the deciding factor here.
- ✓
Microsoft 365 Outlook
Why this is correct
Microsoft 365 Outlook is a cloud service, so canvas apps connect to it through the built-in Office 365 Outlook connector using standard authentication. No on-premises data gateway is required because the data never resides behind a corporate network boundary.
- ✓
SharePoint Online list
Why this is correct
SharePoint Online is a cloud-hosted service, so the SharePoint connector authenticates directly against Microsoft 365 over the internet. Because the list lives in the cloud rather than behind a corporate firewall, no on-premises data gateway is needed to reach it.
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.