PL-900 Demonstrate the capabilities of Power Apps Practice Question
A Power Apps developer created a canvas app that uses a SQL Server data source. Users report that the app is slow when navigating between screens. Which design change should the developer make to improve performance?
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
✓
Apply delegation-compatible filters on galleries to reduce data loaded from the server.
To improve performance in a canvas app with a SQL Server data source, the most effective design change is to apply delegation-compatible filters on galleries (option D). Delegation allows the server to process the filtering, reducing the amount of data transferred to the app and speeding up screen navigation. Option A is incorrect because replacing SQL Server with SharePoint does not inherently improve delegation; both support delegation, but the root cause is unfiltered data loads. Option B is wrong because moving logic to App.OnStart preloads data only once, not per screen, and doesn't address data volume during navigation. Option C is incorrect because preloading with a Timer control adds complexity and does not reduce the data transferred; delegation is the proper solution.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Replace the SQL data source with a SharePoint list to increase delegation limits.
Why it's wrong here
SharePoint has lower delegation limits than SQL.
- ✗
Move all data loading logic from OnVisible to the App.OnStart property.
Why it's wrong here
This does not reduce data transfer; it may delay initial load.
- ✗
Add a Timer control to preload data for the next screen.
Why it's wrong here
Preloading increases data consumption and does not address the root cause.
- ✓
Apply delegation-compatible filters on galleries to reduce data loaded from the server.
Why this is correct
Delegation pushes filtering to SQL, reducing data sent to the app.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 904-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.