Exam DP-600 topic 1 question 149 discussion

Actual exam question from Microsoft's DP-600

Question #: 149
Topic #: 1

HOTSPOT
-

You have a Fabric lakehouse named Lakehouse1 that contains the following data.

You need build a T-SQL statement that will return the total sales amount by OrderDate only for the days that are holidays in Australia. The total sales amount must sum the quantity multiplied by the price on each row in the dbo.sales table.

How should you complete the 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 testtaker45 at Jan. 28, 2025, 1:10 a.m.

Comments

Submit Cancel

testtaker45

Highly Voted 3 months ago

Sum(s.Quantity * s.UnitPrice), Inner So I think the first one is just syntax. Ensure it looks correct. For the type of Joins, they only want it if it is Australia. Inner will only bring over the matches, making it an ideal Join Type. To be fair, I had to look it up, but once I learned that I wanted to share.

upvoted 8 times

YellowSky002

1 month, 4 weeks ago

So what is the difference between the 2 and 3 choices of the first option. If the price does not change, what difference would it make?

upvoted 1 times

k0s

3 weeks, 1 day ago

In the third option, "quantity" is written in lowercase instead of "Quantity", and that's what makes the difference and makes the second option correct.

upvoted 1 times

...

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 149 discussion

Comments

testtaker45

YellowSky002

k0s

SY0-701