Microsoft
70-433 · Question #10
70-433 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
You have two tables named Customers and Orders. They are related by a foreign key constraint on the CustomerID on each table. You need to generate the following XML structure that includes all customers and their related orders. <Root> <Customer> <CustomerName>Customer1</CustomerName> <Orders> <Order> <OrderDate>1/1/2008</OrderDate> <OrderValue>422</OrderValue> </Order> <Order> <OrderDate>4/8/2008</OrderDate> <OrderValue>300</OrderValue> </Order> ... </Orders> ... </Customer> <Root> Which query should you use?
Options
- ASELECT CustomerName,
- BSELECT *
- CSELECT CustomerName,
- DSELECT CustomerName,
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.