You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must connect to a remote database to retrieve data. The structure of the remote database is shown in the exhibit. (Click the Exhibit button.)
You write the following lines of code. (Line numbers are included for reference only.)
01 Partial Friend NotInheritable Class Settings
02 Inherits System.Configuration.ApplicationSettingsBase
03 < System.Configuration.SpecialSettingAttribute ( _
04 System.Configuration.SpecialSetting.ConnectionString )>
05 ...
06 Public ReadOnly Property ExcelSQLConnectionString () _
As String 07 Get 08 Return Convert.ToString (Me(" ExcelSQLConnectionString ")) 09 End Get 10 End Property 11 End Class
You need to connect to the remote database by using the security context of the current user.
Which code segment should you insert at line 05?

• A. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Production;Integrated Security=True")> _
• B. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL ;InitialCatalog = AdventureWorks ." & _ " Production.Product;Integrated Security=True")> _
• C. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL;Initial Catalog= AdventureWorks ;" & _ "Integrated Security=True")> _
• D. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Product;Integrated Security=True")> _

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 item1.xml file.
• D. Delete the itemProps1.xml file.

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The solution will insert an XML data island in a Word document. The data island contains the following XML fragment.
< customer id="01AF" >
< region district="Northwest" > < /region >
< /customer >
You bind the data island to an XMLNode instance named xln.
You need to update the region element with the following data.
< customer id="01AF" >
< region district="Southwest" > California < /region >
< /customer >
Which code segment should you use?

• A. If xln.ChildNodes (0).Text = "customer" _ AndAlso xln.NodeText = "Northwest" Then xln.NodeText = "Southwest" xln.ChildNodes (1).Text = "California" End If
• B. If xln.ParentNode.NodeValue = "customer" _ AndAlso xln.NodeValue (0). CompareTo ("Northwest") = 0 Then xln.NodeText = " California " xln.ChildNodes (1).Text = "Southwest" End If
• C. If xln.ParentNode.NodeValue = "customer" _ AndAlso xln.NodeText = "Northwest" Then xln.NodeText = "Southwest" xln.ChildNodes (1).Text = " California " End If
• D. If xln.ChildNodes (0).Text = "customer" _ AndAlso xln.NodeValue (0). CompareTo ("Northwest") = 0 Then xln.NodeText = " California " xln.ChildNodes (1).Text = "Southwest" End If

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The solution must meet the following requirements: The solution must save the document.
The users who do not have Microsoft VSTO Runtime installed can open the document. You need to ensure that the solution meets the requirements.
Which code segment should you use?

• A. Me.RejectAllRevisionsShown () Me.Save ()
• B. Me.RemoveTheme () Me.Save ()
• C. Me.RemoveCustomization () Me.Save ()
• D. Me.ReloadAs ( Microsoft.Office.Core.MsoEncoding . _ msoEncodingAutoDetect ) Me.Save ()