DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

Question

You have the following KQL query.

Question Image

For each statement, select Yes if it is true. Otherwise, select No.

Yes or No

Statements	Yes	No
The query excludes sales that have a Status of Cancelled.
The query calculates the total sales of each product category for the last 30 days.
The query includes product categories that have had zero sales during the last 30 days.

Explanation

The first where operator excludes records with Status == "Cancelled". The date filter limits input records to the prior 30 days, and summarize sum(SalesAmount) by ProductCategory calculates category totals. The final where TotalSales > 0 removes categories whose computed total is zero.

DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

AstroTutor

Notes

Readiness

QuestionQ18

Community Discussion