Free Microsoft 70-543 Exam Dumps Questions & Answers

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.Delete the itemProps1.xml file.
• B.Create a file named itemProps2.xml that marks the item2.xml file as a data store.
• C.Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the itemProps1.xml file.
• D.Delete the item1.xml file.

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

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Private pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub CreatePane ()
pane = Me.CustomTaskPanes.Add (New UserControl (), _
"Do Something")
pane.Visible = True
End Sub
You need to ensure that only a single instance of the custom task pane is displayed in each single document interface (SDI) window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Create the following event handler for the Application.DocumentOpen event. Private Sub Application_DocumentOpen ( ByVal Doc As Word.Document ) CreatePane () End Sub
• B.Create the following event handler for the Application.ActiveDocument.New event. Private Sub ActiveDocument_New () CreatePane () End Sub
• C.Create the following event handler for the ThisAddIn.StartUp event. Private Sub ThisAddIn_Startup _ ( ByVal sender As Object, ByVal e As System.EventArgs ) CreatePane () End Sub
• D.Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ ( ByVal Doc As Word.Document , ByVal Wn As Word.Window ) CreatePane () End Sub
• E.Create the following event handler for the Application.NewDocument event. Private Sub Application_DocumentNew ( ByVal Doc As Word.Document ) CreatePane () End Sub

You are creating an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application edits a Microsoft Office Word 2007 document. The Word document contains two XML parts. The second custom XML part is used to audit changes to the first custom XML part. You need to ensure that the application adds a new element to the second XML part each time the value of a text node in the first XML part is changed. What should you do?

• A.Modify the StreamAfterAdd event for the CustomXMLParts collection.
• B.Modify the NodeAfterInsert event for the first CustomXMLPart object.
• C.Modify the StreamAfterLoad event for the CustomXMLParts collection.
• D.Modify the NodeAfterReplace event for the first CustomXMLPart object.

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution is frequently updated. You need to deploy the solution. You also need to ensure that users have access to previous versions of the solution. What should you do?

• A.Create a setup project and build a Microsoft Windows Installer file. Run the Windows Installer file to install the solution to a shared folder. As changes are made, rebuild the Windows Installer file and reinstall the solution.
• B.Copy the solution to a shared folder on the local network. As changes are made, copy the updated files to the shared folder.
• C.Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.
• D.Copy the solution to a local folder on each client computer. As changes are made, copy the updated files to the local folder.