Exam DP-600 Topic 1 Question 26 Discussion

Explanation:

We are analyzing this KQL query:
Sales
| where Status != "Cancelled"
| where OrderDate >= ago(30d)
| summarize TotalSales = sum(SalesAmount) by ProductCategory
| where TotalSales > 0
Statement 1:
"The query excludes sales that have a Status of Cancelled."
Yes # where Status != "Cancelled" filters them out.
Statement 2:
"The query calculates the total sales of each product category for the last 30 days." Yes # where OrderDate >= ago(30d) ensures only last 30 days.
summarize TotalSales = sum(SalesAmount) by ProductCategory groups by category.
Statement 3:
"The query includes product categories that have had zero sales during the last 30 days." No # The final filter where TotalSales > 0 excludes categories with zero sales.
Final Answer:
Excludes Cancelled sales # Yes
Calculates total sales by product category for last 30 days # Yes
Includes product categories with zero sales # No
References:
KQL where operator
KQL summarize operator