Microsoft 70-543 PDF download - Education - Study Techniques

TS: Visual Studio Tools for 2007 MS Office System (VTSO) 70-543 Test

Microsoft 70-543 (VB)

Question: 1You create a Microsoft Office Excel 2007 workbook.You save the workbook in the C:Data folder as an OpenXML package. You copy a file namedData.xml from the C:Data folder to the CustomXML folder in the package. You rename thecopied file to Item1.xml.You add the following XML fragment to the Document.xml.rels file in the package.< Relationship Id="rId1"Type="/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. /Data/Data.xmlB. /CustomXML/Item1.xmlC. C:/Data/Data.xmlD. C:/Data/CustomXML/Item1.xml

Answer: B

Question: 2You create a custom workbook for Microsoft Office Excel 2007 by using Visual Studio Tools forthe Microsoft Office System (VSTO).The workbook contains the following data:Static dataData that is imported from .xml filesThe workbook displays the imported data by using mapped ranges.You need to send only the imported data to a user.What should you do?

A. Save the workbook as an .xml file, and then send the Workbook.xml file to the user.B. Save the workbook as a .zip file, and then send the Workbook.xml file that is contained in the .zip file to the user.C. From the Developer Ribbon user interface, export the XML data as an .xml file by using the Export command. Send the .xml file to the user.D. From the Design Ribbon user interface, export the XML data to a Microsoft Windows SharePoint Services list by using the Export command. Send the link from the Microsoft Windows SharePoint Services list to the user.

Answer: C

Question: 3You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for theMicrosoft Office System (VSTO).You add two Text content controls named control1 and control2 to the template.The template contains the following custom XML fragment.< ProductList >

Chai

ChangYou need to ensure that control1 displays the id of the Product and control2 displays the name ofthe Product.Which code segment should you use?

A. Control1.XMLMapping.SetMapping _ ("/ ProductList /Product/id", "", _Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ProductList/Product/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))B. Control1.XMLMapping.SetMapping _ ("/ ProductList /Product/@id", "", _Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ProductList/Product/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))C. Control1.XMLMapping.SetMapping _ ("/ ProductList /Product[1]/id", "", _Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ProductList/Product[1]/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))D. Control1.XMLMapping.SetMapping _ ("/ ProductList /Product[1]/@id", "", _Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ProductList/Product[1]/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))

Answer: D

Question: 4You are creating a custom template for Microsoft Office Word 2007 by using Visual Studio Toolsfor the Microsoft Office System (VSTO).The template contains a custom XML part that consumes data from an XML source. The XMLsource contains the following XML fragment. mother board, memory, hard drive, floppy drive, DVD drive 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.wdContentControlRichText, range)B. Application.ActiveDocument.ContentControls.Add _(WdContentControlType.wdContentControlText, range)C. Application.ActiveDocument.ContentControls.Add _(WdContentControlType.wdContentControlDropdownList, range)D. Application.ActiveDocument.ContentControls.Add _(WdContentControlType.wdContentControlCombobox, range)

Answer: B

Question: 5You are creating a document-level solution for Microsoft Office Word 2003 by using Visual StudioTools for the Microsoft Office System (VSTO). A transformation file is used to convert the solutiondocument to an HTML file. The path to the transformation file is stored in a variable namedfilename. The Uniform Resource Identifier (URI) is stored in a variable named uri. An optionalalias is stored in a variable named alias. You need to ensure that the solution document uses thetransformation file that the user provides. Which code segment should you use?A. Me.Application.XMLNamespaces.Add (filename, uri , [alias], True)B. Me.XMLSchemaReferences.Add ( uri , [alias], filename, True)C. Me.XMLNodes.Add (Name:=filename, Namespace:="")D. Me.XMLSaveThroughXSLT = filename

Answer: D

Question: 6You create a Microsoft Office Word 2007 document. The document will use data from a filenamed Data1.xml. The file is located in the C:Data folder. You create an application by usingVisual Studio Tools for the Microsoft Office System (VSTO). You need to ensure that theapplication adds the data from the Data1.xml file to the document. Which code segment shouldyou use?

A. Document.CustomXMLParts.Add(XML:="")document.CustomXMLParts(1).Load("C:data1.xml")B. Dim control As ContentControl control = document.ContentControls.Add _ (WdContentControlType.wdContentControlText, range) control.XMLMapping.SetMapping( _"C:data1.xml","", document.CustomXMLParts(1))C. Dim xmlPart As CustomXMLPart xmlPart = document.CustomXMLParts.Add(XML:="")xmlPart.DocumentElement.AppendChildNode( _ "xmlPart", uri,MsoCustomXMLNodeType.msoCustomXMLNodeElement, _ "data1.xml")D. Dim control As ContentControl control = document.ContentControls.Add( _WdContentControlType.wdContentControlText, range) control.XMLMapping.SetMapping( _"/data1.xml","", document.CustomXMLParts(1))

Answer: A

Question: 7You are creating a document-level solution for Microsoft Office Word 2003 by using Visual StudioTools for the Microsoft Office System (VSTO). The customization contains a predefined schemato validate the data that users add. The path to the schema is stored in a variable namedfilename. 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 schemathat the user selects is applied to the solution document. Which code segment should you use?

A. Me.XMLNodes.Add (filename, "", uri )B. Me.Application.XMLNamespaces.Add (filename, uri , [alias], True)C. Me.XMLSchemaReferences.Add ( uri , [alias], filename, True)D. Dim doc As ThisDocument = Globals.ThisDocumentMe.Application.XMLNamespaces.Item(uri). _AttachToDocument(doc)

Answer: C

Question: 8You 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 workbookdisplays the data that is contained in an XML file named Salesorder.xml. TheSalesorder.xml file uses an XML schema that is stored in a file named Salesorder.xsd. Both theSalesorder.xml file and the Salesorder.xsd file are located in the C:Data folder. You need toensure that the data in the Salesorder.xml file is available for mapping. Which code segmentshould you use?A. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:DataSalesorder.xsd", "Root")Me.XmlImport("C:DataSalesorder.xml", map, _ True, Globals.Sheet1.Range("A1"))B. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:DataSalesorder.xml", "Root")Me.XmlImport("C:DataSalesorder.xsd", map, _ False, Globals.Sheet1.Range("A1"))C. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:DataSalesorder.xsd", "Root")Me.XmlImportXml ("C:DataSalesorder.xm l", map, _ True, Globals.Sheet1.Range("A1"))D. Dim map As Excel.XmlMap = _ Me.XmlMaps.Add ("C:DataSalesorder.xml", "Root")Me.XmlImportXml ("C:DataSalesorder.xsd", map, _ False, Globals.Sheet1.Range("A1"))

Answer: A

Question: 9You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for theMicrosoft Office System (VSTO). You add a content control to the custom template. The contentcontrol is a placeholder for the first paragraph in the documents that use the custom template.You need to ensure that the users can edit the first paragraph but cannot delete it.Which code segment should you use?

A. Control.LockContentControl = True control.LockContents = FalseB. Control.LockContentControl = True control.LockContents = TrueC. Control.LockContentControl = False control.LockContents = TrueD. Control.LockContentControl = False control.LockContents = False

Answer: A

Question: 10You 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 theitem1.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.xmlfile. What should you do?

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

Question: 11You are creating a document-level solution for Microsoft Office Word 2003 by using Visual StudioTools for the Microsoft Office System (VSTO).The solution document refers to the following bugs:bug123Bug514BUG512The solution document must provide more details about a bug whenever a reference to the bug isfound in the document.You need to create a smart tag that identifies each bug.Which code segment should you use?

A. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "BugRecognizer")Dim regex As Regex = _ New Regex("bugddd", RegexOptions.IgnoreCase)tag.Expressions.Add(regex)B. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "BugRecognizer")Dim regex As Regex = New Regex("[B|b][U|u][G|g]000") tag.Expressions.Add(regex)C. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "BugRecognizer")tag.Terms.Add("bugddd")D. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "BugRecognizer")tag.Terms.Add("[B|b][U|u][G|g]000")

Answer: A

Question: 12You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Toolsfor the Microsoft Office System (VSTO). You create a user control named MyUserControl.You write the following code segment for your document class. (Line numbers are included forreference only.)01 Private Sub ThisDocument_Startup _(ByVal sender As Object, ByVal e As System.EventArgs)02 Dim uc As MyUserControl = New MyUserControl()03 ... 04 End SubYou need to display userControl in the actions pane.Which code segment should you insert at line 03?

A. Me.ActionsPane.Controls.AddRange _ (New Control() {uc, New MyUserControl()})B. Me.ActionsPane.Controls.Add(uc)C. Me.Controls.AddControl(uc, 100, 100, 100, 100, "Action s Pane")D. Me.ActionsPane.Parent.Controls.Add(uc)

Answer: B

Question: 13You are creating a document-level solution for Microsoft Office Word 2003 by using Visual StudioTools for the Microsoft Office System (VSTO).You write the following lines of code in the solution.Dim tag As SmartTag = New _

Original Resource :

Visit 70-543 Link : 70-543 Download PDF Link : 70-543

0