Question 7

Answer D is correct. Because the basis for the procedure is data query, T-SQL is preferred over the CLR implementation. The CLR is preferred in situations that involve complex processing, with no data interaction. 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.