Which object should you use?

Posted by: Pdfprep Category: 70-461 Tags: , ,

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

Answer: C

Leave a Reply

Your email address will not be published.