nerdexam
Microsoft

70-768 · Question #34

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…

The correct answer is E. scalar-valued function. See the full explanation below for the reasoning.

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-SOL statements. You need to create a database object. What should you create?

Options

  • Aextended procedure
  • BCLR procedure
  • Cuser-defined procedure
  • DDML trigger
  • Escalar-valued function
  • Ftable-valued function

How the community answered

(25 responses)
  • A
    4% (1)
  • C
    12% (3)
  • D
    4% (1)
  • E
    80% (20)

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice