Question

In which of the following scenario, using XML native storage would be inappropriate?

(a) Fixed schema

(b) You want to query and modify your XML data

(c) You want to index the XML data for faster query processing

(d) Your application needs system catalog views to administer your XML data and XML schema

I had been asked this question during an interview.

This key question is from Working With XML Data topic in division Beyond Relational of SQL Server

Answer 1

The correct choice is (a) Fixed schema

For explanation I would say: XML is appropriate when we may or may not have a schema for your XML data.