Exam DP-600 Topic 2 Question 184 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.
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