Microsoft
70-457 · Question #16
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements: - Returns a result set based on supplied parameters. - Enables the…
The correct answer is C. Table-valued user-defined function. See the full explanation below for the reasoning.
Question
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
- Returns a result set based on supplied parameters.
- Enables the returned result set to perform a join with a table.
Which object should you use?
Options
- AInline user-defined function
- BStored procedure
- CTable-valued user-defined function
- DScalar user-defined function
How the community answered
(51 responses)- A6% (3)
- B4% (2)
- C78% (40)
- D12% (6)
Community Discussion
No community discussion yet for this question.