Exam 70-762 topic 1 question 79 discussion

Actual exam question from Microsoft's 70-762

Question #: 79
Topic #: 1

DRAG DROP -
You need to build a function that meets the following requirements:
✑ Returns multiple rows
Optimizes the performance of the query within the function

How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL statements to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https://technet.microsoft.com/en-us/library/ms189294(v=sql.105).aspx

by Froze at April 4, 2020, 5:39 p.m.

Comments

Submit Cancel

Froze

Highly Voted 5 years, 2 months ago

Answer is correct. You can notice second option, which will give you also proper result, but because of "Optimizes the performance of the query within the function" you need to chose the simple version, because it runs much faster and usually have simple execution plan.

upvoted 15 times

...

Lukis92

Most Recent 4 years, 9 months ago

Great explanation between multi-statement table-valued function and inline table-valued function: https://stackoverflow.com/a/4109201/4645227

upvoted 4 times

...