HOTSPOT
-
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.
You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
This is a confusing one as both YEAR and ROLLUP would work here.
As I understood, "You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row." means we need build report on 2 levels, top one is year and second level is year plus P.name. I think both ROLLUP and GROUPING SETS can match it. However, ROLLUP will give another row of total summary on whole table level. I cannot say which one this better because no enough information in question.