PL-900 Demonstrate the capabilities of Power Apps Practice Question
A sales team uses a canvas app to manage customer leads. The app currently connects to a SharePoint list as its data source. The team wants to move to a more robust data platform that supports complex relationships between leads, accounts, and contacts. They also need to enforce business rules and security at the data level. Which data source should they use?
⚠ Common exam trap
The trap here is assuming that SharePoint lists with lookup columns can fully replace a relational database for complex business applications.
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
Dataverse is the only option that natively supports complex relationships, business rules, and security at the data level within the Power Platform. It is designed for scenarios requiring robust data modeling and governance, unlike SharePoint lists or Excel, which are better for simpler data storage.
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 via an on-premises data gateway
Why it's wrong here
While SQL Server can handle complex relationships, it requires an on-premises data gateway and does not natively integrate with Power Apps for business rules or security at the data level without additional configuration. It adds complexity and may not provide the seamless experience of Dataverse.
- ✗
Microsoft Excel workbook stored in OneDrive
Why it's wrong here
Excel workbooks are flat files and do not support complex relationships or business rules at the data level. They are suitable for simple data but lack the scalability and security features required for managing leads, accounts, and contacts with enforced rules.
- ✓
Microsoft Dataverse
Why this is correct
Dataverse provides relational data storage, rich metadata, and built-in security roles, making it ideal for complex relationships and business rules. It supports table relationships, business rules, and column-level security, which SharePoint lists lack. This aligns with the team's need for a robust data platform.
- ✗
SharePoint list with lookup columns
Why it's wrong here
SharePoint lists with lookup columns can create simple relationships but do not enforce complex business rules or advanced security at the data level. They are limited in scalability and relational capabilities, making them unsuitable for the team's requirements.
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.