Microsoft
70-451 · Question #36
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…
The correct answer is C. Create columns based on XML elements. See the full explanation below for the reasoning.
Question
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?
Options
- AStore the XML data by using the filestream data type.
- BStore the XML data by using the nvarchar(max) data type.
- CCreate columns based on XML elements.
- DCreate columns based on Extensible Stylesheet Language Transformations (XSLT).
How the community answered
(34 responses)- A3% (1)
- B15% (5)
- C74% (25)
- D9% (3)
Community Discussion
No community discussion yet for this question.