Microsoft
70-433 · Question #20
70-433 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
You have a table named Products.Product. The table has columns ProductID, Name, Size, and Category. You have a variable named @XML with following XML value: <Root> <Category Name="Socks" /> <Category Name="Pants" /> <Category Name="Shirts" /> </Root> You are tasked to write a query that lists the products in Products. Product that match the categories listed in the XML document. You need to write a query to accomplish the task. Which query should you write?
Options
- ASELECT p.ProductID, p.Name, p.Size, p.Category
- BSELECT p.ProductID, p.Name, p.Size, p.Category
- CWITH XMLTable
- DWITH XMLTable
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.