Question 32

Answer C is correct. This is a perfect situation for sending a recordset to the client machine that can then be used by the front-end application to show only the data needed. XML provides a mechanism by which the data is shipped to the client, resides in the background of the client machine, and is presented by the front end in any manner desired. SCHEMABINDING refers only to SQL Server objectsspecifically tables, views, and user-defined functions. An XML schema cannot be bound in this manner. XML resides in memory and is processed against its own internal set of rules, referred to as a schema. An XML schema interacts directly with the data to supply logic and display attributes on the user's browser. HTML does not have the required functionality.

For more information, see the following sources:

  • Chapter 4, "Supporting the XML Framework"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Using XML in SQL Server"

  • "XML Options in Microsoft SQL Server 2005,"

  • "XML Support in Microsoft SQL Server 2005,"

  • Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, XML Best Practices for Microsoft 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 © 2008-2017.
If you may any questions please contact us: