Microsoft
70-433 · Question #21
Your company exchanges information with other companies by using XML and Web services. Your manager asks you to remove a schema collection that is no longer used. Before dropping the schema, you…
The correct answer is D. sys.column_xml_schema_collection_usages. sys.column_xml_schema_collection_usages returns a row for each column that is validated by an
Implement Tables and Views
Question
Your company exchanges information with other companies by using XML and Web services. Your manager asks you to remove a schema collection that is no longer used. Before dropping the schema, you should confirm that it is no longer in use. You need to use a catalog view to determine if the schema collection is being used. Which catalog view should you use?
Options
- Asys.xml_schema_components
- Bsys.xml_schema_namespaces
- Csys.xml_schema_collections
- Dsys.column_xml_schema_collection_usages
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C4% (1)
- D79% (22)
Explanation
sys.column_xml_schema_collection_usages returns a row for each column that is validated by an
Topics
#XML schema collection#catalog views#sys.column_xml_schema_collection_usages#schema management
Community Discussion
No community discussion yet for this question.