Pass with professional 70-543 actual quiz materials

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. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:\Data\Salesorder.xsd", "Root") Me.XmlImport ("C:\Data\Salesorder.xml", map, _ True, Globals.Sheet1.Range("A1"))
• B. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:\Data\Salesorder.xml", "Root") Me.XmlImport ("C:\Data\Salesorder.xsd", map, _ False, Globals.Sheet1.Range("A1"))
• C. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:\Data\Salesorder.xsd", "Root") Me.XmlImportXml ("C:\Data\Salesorder.xml", map, _ True, Globals.Sheet1.Range("A1"))
• D. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:\Data\Salesorder.xml", "Root") Me.XmlImportXml ("C:\Data\Salesorder.xsd", map, _ False, Globals.Sheet1.Range("A1"))

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customization contains a predefined schema to validate the data that users add. The path to the schema is stored in a variable named filename. The Unique Resource Identifier (URI) for the schema is stored in a variable named uri. The alias for the schema is stored in a variable named alias.
You need to ensure that the schema that the user selects is applied to the solution document. Which code segment should you use?

• A. object doc = Globals.ThisDocument; this.Application.XMLNamespaces.get_Item(ref uri). AttachToDocument(ref doc);
• B. this.XMLNodes.Add((string)filename, "", ref uri);
• C. this.XMLSchemaReferences.Add(ref uri, ref alias, ref filename, true);
• D. this.Application.XMLNamespaces.Add((string)filename, ref uri, ref alias, true);

You create an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). You deploy the add-in to a folder on a network share. The folder hosts 20 assemblies. All the assemblies are signed and contain the same digital signature. The add-in runs from a local computer. When the add-in is accessed from a network share by using th e same computer, a security exception is raised. You need to ensure that the add-in can run from the network share. You must achieve this goal without elevating permissions for the other assemblies. What should you do?

• A. Create a code group that is based on the publisher.
• B. Create a code group that is based on the public token that is used to sign the assembly.
• C. Create a code group that is based on the network share URL.
• D. Create a code group that is based on the file hash.

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 document refers to the following bugs:
bug123
Bug514
BUG512
The solution document must provide more details about a bug whenever a reference to the bug is found in the document.
You need to create a smart tag that identifies each bug.
Which code segment should you use?

• A. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); Regex regex = new Regex(@"bug\d\d\d", RegexOptions.IgnoreCase); tag.Expressions.Add(regex);
• B. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); Regex regex = new Regex(@"[B|b][U|u][G|g]000"); tag.Expressions.Add(regex);
• C. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); tag.Terms.Add(@"bug\d\d\d");
• D. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); tag.Terms.Add(@"[B|b][U|u][G|g]000");

You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following code segment for the add-in class.
Dim pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub CreatePane ()
Pane = Me.CustomTaskPanes.Add (New MyUserControl (), _
"Do Something")
pane.Visible = True
End Sub
Users must open multiple workbooks in Excel.
You need to ensure that the add-in displays the same instance of the task pane when a user views any of the open workbooks.
What should you do?

• A. Create the following event handler for the Application.WorkbookActivate event. Private Sub Application_WorkbookActivate _ ( ByVal Wb As Excel.Workbook ) CreatePane () End Sub
• B. Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ ( ByVal Wb As Excel.Workbook , ByVal Wn As Excel.Window ) CreatePane () End Sub
• C. Create the following event handler for the Application.WorkbookOpen event. Private Sub Application_WorkbookOpen ( ByVal Wb As Excel.Workbook ) CreatePane () End Sub
• D. 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