PL-900 Practice Question: Manage the Microsoft Power Platform environment
A company uses Power BI dashboards to monitor real-time production metrics. The dashboards use DirectQuery to a SQL Server database. Users report that the dashboards are slow during peak hours. What is the most effective first step to improve performance?
⚠ Common exam trap
Watch out — candidates often assume performance issues are always solved by scaling up infrastructure (Premium capacity) or switching to Import mode, but the PL-900 exam emphasizes that the first step in troubleshooting DirectQuery slowness is to optimize the source queries and database design, not to add more resources or change the connectivity mode.
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 the SQL queries used in the dataset
Optimizing the SQL queries used in the dataset directly addresses the root cause of slow DirectQuery performance: inefficient queries sent to the SQL Server. DirectQuery translates Power BI visuals into SQL queries executed in real time on the source database, so poorly written or unindexed queries create bottlenecks during peak loads. Improving query efficiency (e.g., adding indexes, reducing joins, filtering early) reduces server load and response time without requiring architectural changes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Optimize the SQL queries used in the dataset
Why this is correct
Optimizing queries reduces load on the source and improves responsiveness.
- ✗
Create aggregations in the dataset
Why it's wrong here
Aggregations can improve performance but query optimization should come first.
- ✗
Increase the Power BI Premium capacity
Why it's wrong here
Scaling up may help but should be done after optimizing queries.
- ✗
Switch the dataset to Import mode
Why it's wrong here
Import mode is not real-time and requires scheduled refresh.
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.