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.