Pass with professional 070-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 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 the public key token to the TypeInfo element in the ContactRef.datasource file.
• B. Add a PublicKeyToken element to the ContactRef.datasource file.
• C. Add the public key token to the GenericObjectDataSource element in the ContactRef.datasource file.
• D. Add a PublicKeyToken attribute to the ContactRef.datasource file.

You are creating a custom workbook for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO).
The workbook will be used to import elements from an XML file named Expense.xml. The Expense.xml file is located in the C:\Data folder.
The schema of the Expense.xml file is stored in a file that is located at C:\Data\Expense.xsd. The schema contains the following XML fragment.
< xsd:element minOccurs ="0" maxOccurs ="unbounded" name=" ExpenseItem ">
< xsd:complexType >
< xsd:sequence >
< xsd:element name="Date" type=" xsd:date "/>
< xsd:element name="Description" type=" xsd:string "/>
< xsd:element name="Amount" type=" xsd:decimal " />
</ xsd:sequence > </ xsd:complexType > </ xsd:element >
You add the schema to the workbook by using a root element named root. You map the cells of the workbook to display the data from each element described in the XML fragment.
You need to ensure that the custom workbook validates the data against the schema.
Which code segment should you use?

• A. this.XmlMaps["root"].SaveDataSourceDefinition = true;
• B. Excel.XmlMap map = this.XmlMaps["root"]; this.XmlImport(@"C:\Data\Expense.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing]);
• C. this.XmlMaps ["root"]. ShowImportExportValidationErrors = true;
• D. Excel.XmlMap map = this.XmlMaps["root"]; this.XmlImportXml(@"C:\Data\Expense.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing]);

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. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImport (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• B. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImport (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• C. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• D. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);

You create a document-level solution for Microsoft Office 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You publish the solution to a folder on a network share. You copy a new version of the solution to a subfolder of the folder. You need to ensure that the users are redirected to the new version of the solution when they open the solution from the network share. What should you do?

• A. Create a deployment manifest in the subfolder. Edit the deployment manifest in the subfolder to point to the new version.
• B. Change the deployment manifest in the main folder of the published solution to point to the new version.
• C. Change the application manifest in the main folder of the published solution to point to the new version.
• D. Create an application manifest in the subfolder. Edit the application manifest in the subfolder to point to the new version.