PL-900 Demonstrate the capabilities of Power Apps Practice Question
A Power Apps maker has built a canvas app that uses a SQL Server database as its data source. The app is used by employees in the office and remote workers. Remote workers report that the app is slow when loading data. The maker suspects that the issue is related to data retrieval. Which action should the maker take to improve performance for remote users?
⚠ Common exam trap
The trap here is focusing on infrastructure changes like gateway placement instead of query optimization, which is often the most effective fix for remote performance issues.
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
✓
Optimize queries to retrieve only necessary data
Optimizing queries to retrieve only the required data minimizes network payload and processing time, which is especially beneficial for remote users with limited bandwidth. This approach is a fundamental performance tuning technique for canvas apps using SQL Server.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable delegation for the SQL Server data source
Why it's wrong here
Enabling delegation allows operations to be processed server-side, but it does not directly address network latency for remote users. While delegation can improve performance, it is not specific to remote access issues and may not resolve slowness if the bottleneck is network-related.
- ✗
Configure an on-premises data gateway in the same region as the remote users
Why it's wrong here
An on-premises data gateway is required to connect to on-premises SQL Server from Power Apps, but placing it in the same region as remote users is not feasible because the gateway must be installed on a machine with network access to the SQL Server, typically on-premises. This does not improve performance for remote users.
- ✗
Use the OnStart property to cache data locally
Why it's wrong here
Caching data in the OnStart property can reduce repeated calls, but it increases initial load time and may not be suitable for large datasets. It also does not address the underlying network latency for remote users and can lead to stale data.
- ✓
Optimize queries to retrieve only necessary data
Why this is correct
Optimizing queries to retrieve only necessary data reduces the amount of data transferred over the network, which directly improves performance for remote users who may have slower connections. This is a best practice for canvas apps connected to SQL Server.
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 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.