DRAG DROP
You are developing an application that will populate an extensive XML tree from a Microsoft SQL
Server 2008 R2 database table named Contacts.
You are creating the XML tree. The solution must meet the following requirements:
Minimize memory requirements.
Maximize data processing speed.
You open the database connection. You need to create the XML tree.
How should you complete the relevant code? (To answer, drag the appropriate code segments to
the correct locations in the answer are
a. Each code segment may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)
Answer: 
I seriously doubt that the answer with the XAttribute is correct. How should an attribute have multiple sub-elements?
You could create an XElement with the name “list” (or whatever), assign the XAttribute “contacts” and attach all the “contact” XElements to it.
Since this is not an option, the answer with the XElement is technically correct.
2
0
I Agree
1
0
I agree. You can see this documentation https://msdn.microsoft.com/en-us/library/mt693096.aspx
1
0
I agree
0
0