Microsoft Fabric Data Engineer Associate DP-700 Practice Question

The GROUP BY CUBE (region, product_category) clause produces all possible grouping combinations of the specified columns. It returns the detailed aggregates for each region-category pair, single-column subtotals for region and product_category, and the grand total (the empty grouping).

GROUP BY ROLLUP returns hierarchical totals but omits the cross-tab subtotals for product_category alone. GROUP BY GROUPING SETS with (region, product_category), (region), (product_category) lacks the grand total because the empty set () is not included. GROUP BY region, product_category returns only the detailed combinations with no subtotals or grand total.