PL-900 Practice Question: Describe the business value of Microsoft Power Platform
Exhibit
Refer to the exhibit. ```kusto SalesSummary | summarize TotalSales = sum(SalesAmount) by Region, ProductCategory | where Region == "North America" | order by TotalSales desc ```
A Power BI report uses the KQL query shown. What is the purpose of this query?
⚠ Common exam trap
Test-takers frequently confuse the `sum()` aggregation with listing individual transactions (Option A) or calculating averages (Option C), overlooking the specific combination of `summarize`, `where`, and `order by` that defines the query's purpose.
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
✓
To show total sales per product category for North America in descending order
The KQL query uses the `summarize` operator to group sales data by `ProductCategory` and calculate the total sales amount using `sum(SalesAmount)`. The `where` clause filters for `Region == 'North America'`, and `order by` sorts the aggregated results in descending order. This produces a list of product categories with their total sales for North America, sorted from highest to lowest.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
To list all sales transactions for North America
Why it's wrong here
The query aggregates data, not lists individual transactions.
- ✓
To show total sales per product category for North America in descending order
Why this is correct
The query sums sales by Region and ProductCategory, filters for North America, and orders by total sales descending.
- ✗
To calculate average sales amount by region
Why it's wrong here
The query calculates sum, not average.
- ✗
To filter sales data by product category
Why it's wrong here
The query groups by product category but does not filter by it.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 904-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 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.