You need to design a method for storing large XML-formatted data. The design must meet
the following requirements: ·Minimize the page I/O ·Minimize the response time for data
manipulation language (DML) queries What should you do?

A.
Create columns based on Extensible Stylesheet Language Transformations (XSLT).
Store the XML data by using the XML data type.

B.
Store the XML data by using the filestream data type.

C.
Store the XML data by using the nvarchar(max) data type.

D.
Create columns based on XML elements. Shred the XML data into the individual
columns.

Explanation: