PL-900 Practice Question: Describe the business value of Microsoft Power Platform
A financial services firm needs to create a compliance dashboard for regulators. The dashboard must display real-time data from multiple sources, including on-premises SQL Server and Dataverse. The firm requires interactive visualizations and the ability to drill down to transaction details. They also need to ensure that sensitive data is masked for certain users. Which Power Platform components should they use?
⚠ Common exam trap
Test-takers frequently confuse Power Automate or Power Apps as dashboard tools, but the question specifically requires interactive visualizations and drill-downs, which are core Power BI capabilities, not automation or app-building features.
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
✓
Power BI, on-premises data gateway, and Dataverse
The scenario requires real-time data from on-premises SQL Server and Dataverse, which necessitates an on-premises data gateway for live connectivity. Power BI provides the interactive visualizations and drill-down capabilities, while Dataverse serves as the unified data source for compliance data. The combination of these components enables real-time dashboards with role-based security for data masking.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Power Automate, AI Builder, and Power BI
Why it's wrong here
Power Automate is not needed for the dashboard itself.
- ✓
Power BI, on-premises data gateway, and Dataverse
Why this is correct
Power BI provides dashboards with RLS, gateway connects to on-premises SQL, Dataverse is another data source.
- ✗
Copilot Studio, Power BI, and Dataverse
Why it's wrong here
Copilot Studio is not needed for compliance dashboards.
- ✗
Power Apps, Dataverse, and Power Automate
Why it's wrong here
Power Apps is not a dashboard tool.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-900 question from scratch — 904 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 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.