Microsoft
70-457 · Question #77
You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements: - Takes an input variable - Returns a table of values Cannot…
The correct answer is D. Stored procedure. See the full explanation below for the reasoning.
Question
You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements:
- Takes an input variable
- Returns a table of values Cannot be referenced within a view
Which object should you use?
Options
- AScalar-valued function
- BInline function
- CUser-defined data type
- DStored procedure
How the community answered
(27 responses)- A15% (4)
- B4% (1)
- C7% (2)
- D74% (20)
Community Discussion
No community discussion yet for this question.