Quick Answer
The correct answers are SharePoint Online and Dataverse, as both are cloud-based data sources that connect directly to a canvas app without requiring an on-premises data gateway. A gateway is only needed when the data source resides behind a firewall on a local network, such as an on-premises SQL Server or Oracle database. On the Microsoft Power Platform Fundamentals PL-900 exam, this question tests your understanding of which connectors are native to the cloud versus those that bridge to on-premises systems. A common trap is assuming that any SQL-based source needs a gateway, but Azure SQL Database is also cloud-native and does not require one—though the exam often limits the correct pair to SharePoint and Dataverse to emphasize the most common cloud connectors. Remember the memory tip: “If it’s in the cloud, no gateway allowed; if it’s on-prem, a gateway is the gem.”
This PL-900 practice question tests your understanding of demonstrate the capabilities of power apps. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)
On-premises SQL Server
Why wrong: On-premises SQL Server requires a data gateway.
On-premises Oracle Database
Why wrong: On-premises Oracle requires a data gateway.
On-premises SAP HANA
Why wrong: On-premises SAP HANA requires a data gateway.
Dataverse
Dataverse is a cloud data source that does not require a gateway.
SharePoint Online
SharePoint Online is a cloud data source that does not require a gateway.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Dataverse
Correct answers: A and C. Option A: SharePoint Online is cloud-based and does not require gateway. Option C: Dataverse is cloud-based. Option B: On-premises SQL Server requires a gateway. Option D: On-premises Oracle requires a gateway. Option E: Azure SQL Database is cloud-based but actually does not require a gateway; however, the question asks for TWO, and both A and C are correct. Azure SQL Database also does not require a gateway, but since we need exactly TWO, we choose A and C. However, note: Azure SQL Database also does not need a gateway, but the stem says 'without using a gateway', and Azure SQL is cloud. But the correct answer set should be A, C, E? Actually, the exam expects that cloud data sources like SharePoint, Dataverse, and Azure SQL do not need a gateway. But since we need exactly two correct, we pick A and C as the most common. I'll adjust: Option E also does not require gateway. But the question is designed to have exactly two correct. Let me change the options to ensure only two are correct. I'll modify: Option E: 'Azure SQL Database' is also cloud, so it would be a third correct answer. To fix, replace Option E with something that requires gateway, e.g., 'SAP HANA on-premises'. But I already set options. I'll keep as is and note that in the answer, only A and C are correct, and E is a distractor because it requires a gateway? Actually, Azure SQL Database does not require a gateway because it's cloud. So my question is flawed. Let me adjust: In the final JSON, I'll change option E to 'On-premises SAP HANA' to make it require a gateway. But I already wrote the explanation. I'll correct in the JSON output by changing option E text and explanation. In the JSON below, I'll set option E to 'On-premises SAP HANA' and mark it false. Also adjust explanation accordingly.
Key principle: NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Common exam traps
NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.
Detailed technical explanation
NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.
Key takeaway
NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated.
Real-world example
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Review the four NAT address types (inside local, inside global, outside local, outside global), PAT port overload, and static vs dynamic NAT use cases. Then practise related PL-900 NAT questions on configuration and troubleshooting.
Demonstrate the capabilities of Power Apps — study guide chapter
Learn the concepts, then practise the questions
Demonstrate the capabilities of Power Apps practice questions
Targeted practice on this topic area only
All PL-900 questions
976 questions across all exam domains
Microsoft Power Platform Fundamentals PL-900 study guide
Full concept coverage aligned to exam objectives
PL-900 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise PL-900 questions linked to Identify foundational components of Power Platform.
Practise PL-900 questions linked to Demonstrate capabilities of Power BI.
Practise PL-900 questions linked to Describe complementary Microsoft Power Platform solutions.
Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.
Practise PL-900 questions linked to Describe the business value of Microsoft Power Platform.
Practise PL-900 questions linked to Manage the Microsoft Power Platform environment.
Practise PL-900 questions linked to Identify foundational components of Microsoft Power Platform.
Practise PL-900 questions linked to Demonstrate the capabilities of Power BI.
Practise PL-900 questions linked to Demonstrate the capabilities of Power Apps.
Practise PL-900 questions linked to Demonstrate the capabilities of Microsoft Copilot Studio.
Practise PL-900 questions linked to Demonstrate the capabilities of Power Pages.
Practise PL-900 questions linked to PL-900 fundamentals.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Demonstrate the capabilities of Power Apps — This question tests Demonstrate the capabilities of Power Apps — Static NAT maps one inside address to one outside address..
The correct answer is: Dataverse — Correct answers: A and C. Option A: SharePoint Online is cloud-based and does not require gateway. Option C: Dataverse is cloud-based. Option B: On-premises SQL Server requires a gateway. Option D: On-premises Oracle requires a gateway. Option E: Azure SQL Database is cloud-based but actually does not require a gateway; however, the question asks for TWO, and both A and C are correct. Azure SQL Database also does not require a gateway, but since we need exactly TWO, we choose A and C. However, note: Azure SQL Database also does not need a gateway, but the stem says 'without using a gateway', and Azure SQL is cloud. But the correct answer set should be A, C, E? Actually, the exam expects that cloud data sources like SharePoint, Dataverse, and Azure SQL do not need a gateway. But since we need exactly two correct, we pick A and C as the most common. I'll adjust: Option E also does not require gateway. But the question is designed to have exactly two correct. Let me change the options to ensure only two are correct. I'll modify: Option E: 'Azure SQL Database' is also cloud, so it would be a third correct answer. To fix, replace Option E with something that requires gateway, e.g., 'SAP HANA on-premises'. But I already set options. I'll keep as is and note that in the answer, only A and C are correct, and E is a distractor because it requires a gateway? Actually, Azure SQL Database does not require a gateway because it's cloud. So my question is flawed. Let me adjust: In the final JSON, I'll change option E to 'On-premises SAP HANA' to make it require a gateway. But I already wrote the explanation. I'll correct in the JSON output by changing option E text and explanation. In the JSON below, I'll set option E to 'On-premises SAP HANA' and mark it false. Also adjust explanation accordingly.
Review the four NAT address types (inside local, inside global, outside local, outside global), PAT port overload, and static vs dynamic NAT use cases. Then practise related PL-900 NAT questions on configuration and troubleshooting.
Static NAT maps one inside address to one outside address.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)
easyWhy C: Options A and C are correct because SharePoint and Microsoft Dataverse are cloud-based data sources that can be accessed directly without a gateway. Options B, D, and E are incorrect because SQL Server on-premises, Oracle on-premises, and SAP on-premises require an on-premises data gateway.
Last reviewed: Jun 21, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.