Which mechanism should you use to implement this functionality?

You have a Research database. The database resides on a SQL Server 2008 database instance named SRV1.
You want users to be able to specify up to 10 string values. Using these specified values, you want to perform complex string comparisons and rank each of the strings with a rating value. Researchers need to store these string values and their corresponding ratings in the Scenario table in the Research database. You want to provide this functionality while optimizing performance and minimal development. Which mechanism should you use to implement this functionality?
A. an extended stored procedure
B. a CLR table-valued function
C. a Transact-SQL multi-statement table-valued function that uses the OVER clause
D. a CLR user-defined aggregate

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.