Exam DP-600 topic 1 question 146 discussion

Actual exam question from Microsoft's DP-600

Question #: 146
Topic #: 1

HOTSPOT
-

You have the following KQL query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by jackjack1 at Jan. 15, 2025, 4:30 p.m.

Comments

Submit Cancel

Acrious

1 month ago

I do not follow how it Yes Yes No. If I specifically state where the OrderDate is Greater than or equal to 30 days, while you could say it includes the 30th day, is to does not include 1-29 at best case.. So why is it Yes (and the explanation at the bottom makes no sense to me)

upvoted 1 times

...

testtaker45

6 months ago

Yes Yes No The code is pretty easy to read. Try to say what each line says. Symbols Explination != means 'is not' >= means greater than or equal to > means greater than. Hope this helps!

upvoted 3 times

...

jackjack1

6 months, 2 weeks ago

Would say yes no no, why would second be yes if we are filtering where sales >0?

upvoted 3 times

JuanGonzalezT

3 months, 2 weeks ago

On its own the sentence is true so is Yes - Yes - No

upvoted 1 times

...

testtaker45

6 months ago

It is yes, yes, no. To answer your inquiry, 'Where OrderDate >= ago(30d)' is read 'Where Order Date is Greater than or equal to 30 days ago' or are less than 31 days old...

upvoted 2 times

...