How should you complete the relevant code?

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 area. 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.)
Select and Place:


microsoft-exams

2 thoughts on “How should you complete the relevant code?

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.