PL-900 Demonstrate the capabilities of Power Apps Practice Question
A small business wants to create a Power Apps app to track customer interactions. They have limited budget and no dedicated IT staff. The app must be easy to maintain and should use a data source that requires minimal setup. The app will be used by 5 sales reps. Which approach should they take?
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
✓
Use a SharePoint list as the data source and a Canvas app
SharePoint lists are easy to set up with no extra licensing (often included with Microsoft 365) and can be used with Canvas apps, which are low-code and easy to maintain. Option A is wrong because Dataverse requires additional licensing and Model-driven apps are more complex to build and maintain. Option B is wrong because Excel on OneDrive does not support multi-user concurrent access reliably and can lead to data conflicts. Option C is wrong because SQL Server requires dedicated infrastructure and maintenance, which is not feasible for a small business with limited budget and no IT staff.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Dataverse as the data source and a Model-driven app
Why it's wrong here
Dataverse requires a premium licence per user, which exceeds the limited budget, and its setup demands database administration skills absent in a business with no IT staff. This option is tempting because Dataverse offers robust relational storage and security for larger enterprises, making it the correct choice when a dedicated IT team and premium licensing are available.
- ✗
Use Excel stored on OneDrive and a Canvas app
Why it's wrong here
Incorrect. Excel stored on OneDrive is not suitable for multi-user concurrent access; it can cause data conflicts and is difficult to maintain for real-time collaboration.
- ✗
Use SQL Server as the data source and a Canvas app
Why it's wrong here
Incorrect. SQL Server requires dedicated infrastructure, maintenance, and administrative effort, which is not feasible for a small business with limited budget and no IT staff.
- ✓
Use a SharePoint list as the data source and a Canvas app
Why this is correct
Correct. SharePoint lists are easy to set up, require minimal administration, and are often included with Microsoft 365 subscriptions. Canvas apps are low-code and easy to maintain, making this combination ideal for the business's constraints.
Go deeper
Related to this question
About these practice questions
One of 904 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.