Microsoft Discussions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Go to Exam

Exam DP-600 topic 1 question 147 discussion

Actual exam question from Microsoft's DP-600

Question #: 147
Topic #: 1

[All DP-600 Questions]

You have a Fabric warehouse that contains a table named SalesOrderDetail, SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.

You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.

Which T-SQL statement should you run?

A.
B.
C.
D.

Show Suggested Answer

Suggested Answer: D 🗳️

by kaixin at Jan. 12, 2025, 2:40 p.m.

Comments

Submit Cancel

JuanGonzalezT

3 months ago

Selected Answer: D

I had a hard time noticing that B said Order and not Partition. The answer is D. You need to do the operation over the whole sale by product.

upvoted 2 times

...

Rataxe

3 months, 2 weeks ago

Selected Answer: B

This partitions by SalesOrderID, which calculates the proportion within each sales order, ensuring the correct context for the calculation.

upvoted 1 times

Acrious

2 weeks, 2 days ago

excepts it an order by , not partition in B, so is D

upvoted 1 times

...

...

MYPE

5 months ago

Selected Answer: D

kaixin is right, "partition by salesorder ID"

upvoted 1 times

...

kaixin

6 months ago

Selected Answer: D

partition by salesorder ID

upvoted 3 times

...