Exam DP-600 topic 1 question 179 discussion

Actual exam question from Microsoft's DP-600

Question #: 179
Topic #: 1

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.

Show Suggested Answer

Suggested Answer:

by Azure_2023 at March 12, 2025, 4:05 p.m.

Comments

Submit Cancel

zxc01

3 months, 1 week ago

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.

upvoted 2 times

...

Azure_2023

5 months, 1 week ago

This is a confusing one as both YEAR and ROLLUP would work here.

upvoted 4 times

Sr18

3 months ago

Year, Year(SO.Modified Date), P.Name Beacause RollUp will cause few extra rows with accumulate values. Grouping set could have been potential ans but Extra Year is throwing me off. But you can test and correct me.

upvoted 2 times

...