DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ8

VerifiedIngest and transform data

You have a Fabric workspace containing a warehouse named DW1. DW1 contains the following tables and columns.

Question Image

You need to create output that shows summarized order quantities by year and product. The results must include an order-quantity summary at the year level across all products.

How should you complete the code?

Select
(SO.ModifiedDate) AS OrderDate
,P.Name AS ProductName
,SUM(SO.OrderQty) AS OrderQty

FROM [dbo].[SalesOrderDetail] SO

INNER JOIN [dbo].[Product] P

ON P.ProductID = SO.ProductID

GROUP BY


ORDER BY OrderDate
Explanation

YEAR extracts the year from ModifiedDate. GROUPING SETS explicitly creates the product-within-year groups and the year-only subtotal across all products, without adding other grouping levels. Microsoft documents that GROUPING SETS defines the exact groupings to calculate.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!