Microsoft
70-433 · Question #19
70-433 Question #19: Real Exam Question with Answer & Explanation
The correct answer is D. WITH XMLNAMESPACES(DEFAULT 'urn:Wide_World_Importers/schemas/. See the full explanation below for the reasoning.
Question
You have the following XML document that contains Product information. DECLARE @prodList xml =' <ProductList xmlns="urn:Wide_World_Importers/schemas/Products"> <Product Name="Product1" Category="Food" Price="12.3" /> <Product Name="Product2" Category="Drink" Price="1.2" /> <Product Name="Product3" Category="Food" Price="5.1" /> ... </ProductList>'; You need to return a list of products that contains the Product Name, Category, and Price of each product. Which query should you use?
Options
- ASELECT prod.value('.[1]/@Name','varchar(100)'),
- BSELECT prod.value('@Name','varchar(100)'),
- CWITH XMLNAMESPACES(DEFAULT 'urn;Wide_World_Importers/schemas/
- DWITH XMLNAMESPACES(DEFAULT 'urn:Wide_World_Importers/schemas/
Community Discussion
No community discussion yet for this question.