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.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net