You are creating an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will display data from a Web service named Service1. Service1 runs on a server named LONDON. The Web service contains a method named GetCustomers that returns a DataSet object. You need to bind the data returned by the GetCustomers method to a DataSet object named ds. Which code segment should you use?

• A. DataSet ds = new DataSet(); ArrayList mappings = new ArrayList(); LONDON.Service1.GenerateXmlMappings( ds.GetType(), mappings);
• B. LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = lh.GetCustomers ();
• C. LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = new DataSet(); ds.GetXml();
• D. LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = new DataSet(); ds.DataSetName = lh.GetCustomers (). GetXml ();

You are creating an application for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). The application will contain a namespace named WordAddInNS.
WordAddInNS will contain the following items:
a class named WordExcelIsland
a method named GetDataIsland
a typed dataset class named WSS_DataSet
You write the following lines of code. (Line numbers are included for reference only.)
01 Private Sub GetDataIsland(ByVal DocPath As String)
02 Dim sd As ServerDocument = New ServerDocument(DocPath)
03 Dim HC As CachedDataHostItemCollection = _
04 sd.CachedData.HostItems
05 If HC.Count > 0 AndAlso _
06 ...
07 End If 08 End Sub
You need to load all the data islands of the WSS_DataSet class from the local document cache.
Which code segment should you insert at line 06?

• A. HC("WordAddInNS.WordExcelIsland").Equals _ ( "WordAddInNS.WSS_DataSet") Then
• B. HC("WordAddInNS.WordExcelIsland").CachedData.Contains _ ( "WSS_DataSet") Then
• C. HC("WordAddInNS.WordExcelIsland").CachedData.Contains _ ( "WordAddInNS.WSS_DataSet") Then
• D. HC("WordAddInNS.WordExcelIsland").Equals("WSS_DataSet") Then

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add the following method to the workbook class.
void NotifyChanges (object Sh , Excel.Range Target) {
//No tify changes
}
You need to set up an event handler that fires NotifyChanges only when the data in the current workbook changes.
Which code segment should you use?

• A. Globals.ThisWorkbook.SheetChange += new Excel.WorkbookEvents_SheetChangeEventHandler ( NotifyChanges );
• B. Globals.ThisWorkbook.Application.SheetChange += new Excel.AppEvents_SheetChangeEventHandler ( NotifyChanges );
• C. Globals.ThisWorkbook.SheetSelectionChange += new Excel.WorkbookEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
• D. Globals.ThisWorkbook.Application.SheetSelectionChange += new Excel.AppEvents_SheetSelectionChangeEventHandler ( NotifyChanges );

You are creating an add-in project for Microsoft Office by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a data source named ContactRef from a class in an assembly. The author digitally signs a new version of the assembly. You need to ensure that the add-in can load a new version of the assembly. What should you do?

• A. Add a PublicKeyToken attribute to the ContactRef.datasource file.
• B. Add a PublicKeyToken element to the ContactRef.datasource file.
• C. Add the public key token to the TypeInfo element in the ContactRef.datasource file.
• D. Add the public key token to the GenericObjectDataSource element in the ContactRef.datasource file.

You create a Microsoft Office Excel 2007 workbook.
You save the workbook in the C:\Data folder as an OpenXML package. You copy a file named Data.xml from the C:\Data folder to the CustomXML folder in the package. You rename the copied file to Item1.xml.
You add the following XML fragment to the Document.xml.rels file in the package.
<Relationship Id="rId1"
Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/CustomXML "
Target="..." />
You need to ensure that the workbook can use the custom XML document part.
Which value should you use for the Target attribute in the XML fragment?

• A. C:/Data/CustomXML/Item1.xml
• B. C:/Data/Data.xml
• C. /CustomXML/Item1.xml
• D. /Data/Data.xml