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

Exam 70-762 All Questions

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

Exam 70-762 topic 1 question 44 discussion

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

Note: this question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in the series. Information and details provided in a question apply only to that question.
You are developing and application to track customer sales.
You need to return the sum of orders that have been finalized, given a specified order identifier. This value will be used in other Transact-SQL statements.
You need to create a database object.
What should you create?

  • A. extended procedure
  • B. CLR procedure
  • C. user-defined procedure
  • D. DML trigger
  • E. scalar-valued function
  • F. table-valued function
Show Suggested Answer Hide Answer
Suggested Answer: F 🗳️
User-defined scalar functions return a single data value of the type defined in the RETURNS clause.
References:
https://technet.microsoft.com/en-us/library/ms177499(v=sql.105).aspx
by q24 at March 24, 2019, 2:27 a.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
q24
Highly Voted 5 years, 8 months ago
the right answer is E, the explanation also refer to this
upvoted 39 times
...
Ben47
Highly Voted 5 years, 5 months ago
Ans is E
upvoted 5 times
...
caeesz
Most Recent 3 years, 10 months ago
E is correct answer
upvoted 2 times
...
Andy7622
4 years, 2 months ago
E (scalar-valued function) returns single value : "You need to return the sum of orders..."
upvoted 2 times
...
stm22
4 years, 4 months ago
yes for return of single value answer = E
upvoted 2 times
...
mamarach
4 years, 5 months ago
Return sum (one value=scalar): thus E is the correct answer
upvoted 3 times
...
strikersree
4 years, 5 months ago
Scalar Valued Function
upvoted 2 times
...
JohnFan
4 years, 9 months ago
How about C. user-defined procedure ?
upvoted 1 times
Froze
4 years, 8 months ago
No. You need to point answer which fits the best. For ONLY returning value you need to thing about function. There is a requirement "This value will be used in other Transact-SQL statements". That also point to function, because you what to use the value - function is the best. So i would point answer E.
upvoted 3 times
...
NickMane
4 years, 2 months ago
still trolling and missleading
upvoted 4 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago