Microsoft 70-461 Exam Dumps

70-461 Question 12

 

 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?

A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function

Correct Answer: C