ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam
Go to Exam

Exam 70-761 topic 1 question 144 discussion

Actual exam question from Microsoft's 70-761
Question #: 144
Topic #: 1
[All 70-761 Questions]

You need to create a database object that meets the following requirements:
✑ accepts a product identifies as input
✑ calculates the total quantity of a specific product, including quantity on hand and quantity on order
✑ caches and reuses execution plan
✑ returns a value
✑ can be called from within a SELECT statement
✑ can be used in a JOIN clause
What should you create?

  • A. an extended stored procedure
  • B. a user-defined table-valued function
  • C. a user-defined stored procedure that has an OUTPUT parameter
  • D. a memory-optimized table that has updated statistics
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
References:
https://www.techrepublic.com/blog/the-enterprise-cloud/understand-when-to-use-user-defined-functions-in-sql-server/
by raf77 at Sept. 3, 2019, 9:22 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Anette
5 years ago
Answer is B. And this question is the same with Q14 and Q120 as well
upvoted 3 times
...
Bel
5 years, 1 month ago
Shouldn't this be C? Can return a value with an OUTPUT parameter too.
upvoted 1 times
Jem12124321423
4 years, 12 months ago
No cause stored procedures cant be called in select
upvoted 3 times
...
...
raf77
5 years, 9 months ago
Probably typo in text. The correct answer to this question: a user-defined scalar function
upvoted 4 times
Bartek
5 years, 9 months ago
No. "..can be used in a JOIN clause.." Scalar UDF cannot be used in Join
upvoted 13 times
...
sunz_1
4 years, 9 months ago
total quantity AND quantity on hand, two outputs
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel