Microsoft : 70-543 Questions & Answers

You are creating a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The template contains a custom XML part that consumes data from an XML source. The XML source contains the following XML fragment.
<Products> mother board, memory, hard drive,
floppy drive, DVD drive </Products>
You need to display the Products element as a comma-separated list within a paragraph of text.
Which code segment should you use?

• A. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlComboBox , ref range);
• B. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlDropdownList , ref range);
• C. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlText , ref range);
• D. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlRichText , ref range);

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains an instance of a data island named SalesDataSet. You create an instance of the CachedDataHostItemCollection object named HC in the add-in. You need to load the content from a CachedDataHostItem object in HC into SalesDataSet. Which code segment should you use?

• A. string di = HC[0].CachedData[0].Xml; using (System.IO.StringReader rdr = new System.IO.StringReader(di)) { northwindDataSet.ReadXml(rdr); northwindDataSet.AcceptChanges(); }
• B. string di = HC[0].CachedData[0].DataType.ToString(); using (System.IO.StringReader rdr = new System.IO.StringReader(di)) { northwindDataSet.ReadXml(rdr); northwindDataSet.Reset(); }
• C. string di = HC[0]. CachedData [0]. DataType.GetType ().ToString(); using ( System.IO.StringReader rdr = new System.IO.StringReader ( di )) { northwindDataSet.ReadXml ( rdr ); northwindDataSet.Reset (); }
• D. string di = HC[0].CachedData[0].GetType().ToString(); using (System.IO.StringReader rdr = new System.IO.StringReader(di)) { northwindDataSet.ReadXml(rdr); northwindDataSet.AcceptChanges(); }

You create a Microsoft Office Word 2007 document.
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?

• A. Create a file named itemProps2.xml that marks the item2.xml file as a data store.
• B. Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the itemProps1.xml file.
• C. Delete the itemProps1.xml file.
• D. Delete the item1.xml file.

You create an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application modifies a Microsoft Office Excel custom workbook. The custom workbook displays the data that is contained in an XML file named Salesorder.xml. The Salesorder.xml file uses an XML schema that is stored in a file named Salesorder.xsd. Both the Salesorder.xml file and the Salesorder.xsd file are located in the C:\Data folder. You need to ensure that the data in the Salesorder.xml file is available for mapping. Which code segment should you use?

• A. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImport (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• B. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImport (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• C. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• D. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A. doc.CachedData.FromXml(filepath);
• B. doc.CachedData.HostItems.Add(filepath);
• C. StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
• D. StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());