You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has its headquarters in Washington and branch offices in Detroit and Delaware. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional.
The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that is located at headquarters. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the entire company. While Certkiller -DB01 is offline for maintenance purposes, all sales data are collected in XML documents. Once Certkiller -DB01 is back online, you must add the data from the XML documents to the CK_Sales database.
What should you do?
A.
Use the FOR XML clause to extract the data and store it in the database.
B.
Use the OPENXML statement to extract the data and store it in the database.
C.
Use XQuery to extract the data and store it in the database.
D.
Use XML DML to extract the data and store it in the database.
Explanation:
The OPENXML statement to extract data from an XML document and stores in a SQL Server 2005 database.
Incorrect Answers:
A: The FOR XML clause is used in a SELECT statement to query a SQL database and format the result set in an XML document. It is not used to query a XML document.
C: XQuery can be used to query and process data in an XML document. It is not used to extract data from the XML document and store in a SQL database.
D: XML DML can be used to perform insert, delete and update operations on the XML document. It is not used to extract data from the XML document and store in a SQL database.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: XML [SQL Server], FOR XML clause
Microsoft SQL Server 2005 Books Online (2006), Index: XML [SQL Server], OPENXML statement
Microsoft SQL Server 2005 Books Online (2006), Index: XML [SQL Server], XQuery Microsoft SQL Server 2005 Books Online (2006), Index: XML [SQL Server], DML