Question 8

Answer C is correct. Because the basis for the procedure is complex calculations and not just data-centric activities, using the CLR is preferred over T-SQL. Parameters are needed to send the options from the client and return the data to the grid.

For more information, see the following sources:

• Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "SQL Server Programming Reference, Database Engine .NET Framework Programming, Introduction to Common Language Runtime (CLR) Integration, Overview of CLR Integration"

• "Using CLR Integration in SQL Server 2005," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp

• Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, Using CLR Integration in SQL Server 2005.