Exam DP-600 topic 1 question 117 discussion

Actual exam question from Microsoft's DP-600

Question #: 117
Topic #: 1

HOTSPOT
-

You have a Fabric tenant that contains a warehouse named WH1.

You run the following T-SQL query against WH1.

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 Martin_Nbg at Oct. 6, 2024, 9:49 a.m.

Comments

Submit Cancel

Martin_Nbg

Highly Voted 8 months, 2 weeks ago

Correct answer is no-no-yes. You couldn't select columns from the return value of a scalar function as done in line 4 and 5 of the SQL code.

upvoted 18 times

adane

5 months, 3 weeks ago

Agree NO NO YES No, Dimension.getDirectReports is not a scalar function; it is a table-valued function (TVF). Why is it a Table-Valued Function (TVF)? 1. OUTER APPLY Usage: o The OUTER APPLY operator is specifically designed to work with functions that return a result set, which can be thought of as a table. This indicates that Dimension.getDirectReports returns multiple rows and columns, making it a table-valued function. No, the Dimension.getDirectReports function will run once for every row in the Dimension.employee table when the query runs. This is because OUTER APPLY evaluates the function for each row in the outer (main) table. Yes, the output of the query using OUTER APPLY will include at least one row for each row in Dimension.employee, even if the Dimension.getDirectReports function does not return any results for some rows.

upvoted 7 times

...

4f3a33d

7 months, 2 weeks ago

A scalar function returns one value. (Ref No for the first)

upvoted 5 times

...