You are a database developer. You plan to design a database solution by using SQL Server
2008. You are writing a query that returns XML data from a table in a database. You need to
ensure that your result set is encapsulated within a root element. What should you do?
A.
Use the AUTO mode along with a ROOT directive.
B.
Use the RAW mode along with an ELEMENTS directive
C.
Use the PATH mode along with a ROOT directive.
D.
Use the EXPLICIT mode along with a TYPE directive.