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.
Store the XML data by using the filestream data type.
B.
Store the XML data by using the nvarchar(max) data type.
C.
Create columns based on XML elements. Shred the XML data into the individual columns.
D.
Create columns based on Extensible Stylesheet Language Transformations (XSLT). Store the XML data by using the XML data type.