PL-900 Demonstrate the capabilities of Power Apps Practice Question
Which TWO data sources can be directly connected to a canvas app without using a premium connector?
⚠ Common exam trap
PL-900 often tests the difference between standard and premium connectors, and candidates frequently mistake Dataverse or SQL Server as standard because they are commonly used in demos, leading to incorrect selections.
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
✓
Excel (OneDrive/SharePoint)
Option A (Excel in OneDrive/SharePoint) is correct because Excel workbooks stored in OneDrive for Business or SharePoint are accessed through the standard Excel connector, which is a non-premium (Standard) connector included with Power Apps. Option C (SharePoint) is correct because the SharePoint connector is also a Standard connector, allowing canvas apps to read and write SharePoint lists and libraries without a premium license. Option B (Microsoft Dataverse) is incorrect because Dataverse requires premium licensing/connectors. Option D (SQL Server) is incorrect because the SQL Server connector is a premium connector. Option E (Salesforce) is incorrect because the Salesforce connector is a premium connector.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Excel (OneDrive/SharePoint)
Why this is correct
Excel workbooks stored in OneDrive for Business or SharePoint use the standard Excel connector, which is included in the Power Apps seeded licence. It therefore connects directly without consuming a premium connector, satisfying the no-premium-connector constraint in the stem.
- ✗
Microsoft Dataverse
Why it's wrong here
Microsoft Dataverse is a premium connector, so it cannot be used without a premium licence. It is tempting because Dataverse is the native Power Platform data store, but it would be correct when the app is licensed for premium connectors, not when only standard connectors are permitted.
- ✓
SharePoint
Why this is correct
SharePoint lists connect through the standard SharePoint connector, bundled with the seeded Power Apps licence rather than premium. It therefore links directly without a premium connector, satisfying the stem's no-premium-connector requirement alongside other standard sources.
- ✗
SQL Server
Why it's wrong here
SQL Server requires the premium SQL Server connector, so it cannot be added without a premium licence. It is tempting because SQL Server is a common canvas data source, and would be correct where the tenant already holds premium licences or uses an on-premises data gateway.
- ✗
Salesforce
Why it's wrong here
Salesforce connects through a premium connector, so it cannot be used without premium licensing. It is tempting because Salesforce is a widely used CRM and integrates with Power Platform, and would be correct where premium connectors are licensed for CRM data scenarios.
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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.