PL-900 Demonstrate the capabilities of Power Apps Practice Question
A team is building a canvas app that must allow users to work with data from multiple sources. The app will use Microsoft Dataverse as the primary data source and also needs to display data from an on-premises SQL Server database. Which two components are required to connect the canvas app to the on-premises SQL Server data? (Choose two.)
⚠ Common exam trap
The trap here is thinking that a Power Automate flow or virtual table is needed to access on-premises data, when the gateway and connector alone are sufficient for canvas apps.
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
✓
An on-premises data gateway installed and configured.
To connect a canvas app to an on-premises SQL Server database, the maker must install and configure an on-premises data gateway to bridge the cloud and local network, and then add the SQL Server connector to the app. These two components together enable secure, direct data access from the canvas app without additional workflows or virtual tables.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A virtual table created in Microsoft Dataverse for the SQL Server data.
Why it's wrong here
Virtual tables in Dataverse allow model-driven apps to display external data, but they are not required for a canvas app to connect directly to SQL Server. Canvas apps can use the SQL Server connector independently, so creating a virtual table adds unnecessary complexity.
- ✗
A Power Automate flow that triggers on app load.
Why it's wrong here
Power Automate flows can automate processes but are not required to establish a direct data connection from a canvas app to an on-premises SQL Server. The app can connect directly through the SQL Server connector using the gateway, so a flow is unnecessary for basic data access.
- ✗
An Azure Logic Apps workflow to synchronize the data.
Why it's wrong here
Azure Logic Apps is a separate integration service that can synchronize data, but it is not a prerequisite for a canvas app to read from or write to an on-premises SQL Server. The direct connector and gateway are sufficient for real-time data access without an intermediate workflow.
- ✓
An on-premises data gateway installed and configured.
Why this is correct
An on-premises data gateway is required to securely connect cloud services like Power Apps to on-premises data sources such as SQL Server. It acts as a bridge, allowing the canvas app to query and write data without exposing the database directly to the internet.
- ✓
The SQL Server connector added to the canvas app.
Why this is correct
The SQL Server connector is the specific connector in Power Apps that enables connection to SQL Server databases. Once the gateway is configured, adding this connector to the app allows the maker to browse tables and use data within the app.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-900 question from scratch — 701 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.